Moving MySQL Cold Backup to Another DB Server

I am new to MySQL and want to know the info whether taking a cold backup from source and copying it onto new server with same version require any additional configurations settings to be changed.

As I have gone through few of the tutorials, none of the config changes are required.

Steps I am following

• Shutting down source server

• copying the backup (/var/lib/mysql).

• importing backup to new server (/var/lib/mysql).

• Start the new server.

Thanks in advance

You missed three(3) things

• On DB1, mysql -uroot -ppassword -e"SET GLOBAL innodb_fast_shutdown = 0"

• On DB1, service mysql stop (DB1)

• Copying the backup (/var/lib/mysql) on DB1

• Copy /etc/my.cnf on DB1 to /etc folder on DB2

• Importing DB1 backup to DB2 (/var/lib/mysql)

• On DB2, chown -R mysql:mysql /var/lib/mysql

• Start mysql on DB2

Step 1 flushes everything InnoDB not yet committed to disk. That makes for a faster mysql startup.

From here, you have the option of changing settings

Give it a Try !!!

StackExchange Database Administrators Q#48198, answer score: 6