Database backup and Restore

[Bruce1952]

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.

[torvista]

I use this all the time for the same purpose:

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

[Bruce1952]

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

[mprough]

That does not work on the godaddy server sorry

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

[Bruce1952]

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.

[torvista]

>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.

[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.

[dbltoe]

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.

[carlwhat]

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.

[Bruce1952]

Hi Carlwhat,

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

It is greatly appreciated.