MySQL

Transfer easily a Mysql Dump between two servers

February 10, 2007 Charles Collier Database, Linux, MySQL, 0

#Dump of the master database $ mysqldump -u user -p db_test > /var/dump/db_test.dat #Copy the dump file db_test.dat with scp to the slave mysql database $ scp /var/dump/db_test.dat user@nuxora.com:/var/backup/db_test.dat #Restore database on the slave server from the master server $ ssh user@nuxora.com ‘mysql -u user -p db_test < /var/backup/db_test.dat’ it is quite simple and efficient. [...]