Re: Move database to a new machine

[Frenco LTD]

1. Backup Database

Backup the database using the following command:

2. Move Database Files

If you have changed any files in the database directory, move them to the new location. If you haven't changed anything, skip this step.

mv /var/lib/mysql/db_name/* /var/lib/new_db_name/

3. Restore Database

Restore the database using the following commands:

4. Change User Password

Change the password for the mysql user using the following command:

UPDATE users SET PASSWORDPASSWORD('password') WHERE USER'root';

5. Restart MySQL Server