http://dba.stackexchange.com/questions/48198/moving-mysql-cold-backup-to-another-db-server
- 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