Database backup and Restore

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.4

CKEditor version 5

Image Handler version 5

I have updated nearly all files on my developement site and have one question related to the database.

Can I backup the live database and then do a restore to the development database site. They are on the same Server and same sofware runing.

Would I have any issues doing this and would anyone have steps (simple ones please)

Once again any assistance would be appreciated.

I use this all the time for the same purpose:

https://github.com/torvista/Zen_Cart...p_MYSQL_Plugin

Quote:

---

Originally Posted by torvista

I use this all the time for the same purpose:

https://github.com/torvista/Zen_Cart...p_MYSQL_Plugin

---

That does not work on the godaddy server sorry

Quote:

---

Originally Posted by Bruce1952

That does not work on the godaddy server sorry

---

Use phpMyAdmin https://docs.phpmyadmin.net/en/lates...rt_export.html

Quote:

---

Originally Posted by mprough

Use phpMyAdmin https://docs.phpmyadmin.net/en/lates...rt_export.html

---

Thanks for that but what I need to know is the following please.

1. I have downloaded the database file which is from the live site no issue and example name MSQL_Live

2. I have two databases Live and Dev and I am wanting to update the DEV database from the Live database.

3. Question regarding the file name.

Do I need to change the database file name from the Live database(downloaded one) before I do a restore into the DEV database.

Just want clear instructions before I attempt to play with the database.

PHP admin allows to restore from file to the database.

>Do I need to change the database file name from the Live database(downloaded one) before I do a restore into the DEV database.

No.

Thank you Torvista for the advice.

So I just restore the live file into the dev site database via PHPadmin and hopefully don't stuff up the restore process.

One other thing will it change passwords or only restore data.

Just want to be safe but then again it is only the dev database.

Think about it like a two-car garage with your car on the left and a truck on the right. If you decide to swap places with them, you won’t change the opener (DB name) used for the left side, but you will surely have to make sure you have the matching key (admin credentials) for the vehicle now on the left.

Quote:

---

Originally Posted by Bruce1952

Thank you Torvista for the advice.

So I just restore the live file into the dev site database via PHPadmin and hopefully don't stuff up the restore process.

One other thing will it change passwords or only restore data.

Just want to be safe but then again it is only the dev database.

---

admin passwords and user passwords are stored in the database. so if you restore your live backup into your dev database, the admin passwords in the dev system will now be the same as your live system.

Hi Carlwhat,

Thank you for confirming what will happen once I update the dev site database.

It is greatly appreciated.

Hi Al,

I restored the live database to the dev database and it all appears to be done and information is the same as the live site at present.

The only thing was the dev site became live as well as the live site. I only had to put the dev site back to maintenance.

Thanks for the assistance with the database update it is really appreciated.