Marc's Blog

Derpa Derpa.

Migrating Mysql Between Servers

Especially if it’s a large bunch of data, just using SSH, gzip and pipes is a good solution imho:

mysqldump -uUSER -pPASS --single-transaction --extended-insert --quick -v DATABASENAME | gzip | ssh -C user@newserver  "gunzip | mysql -uUSER -pPASS DATABASENAME"