HOWTO: Moving MySQL

This is how I do it:

Old server:

cd /var/lib/mysql
tar -zcvf filename.tgz databasename

New server:

cd /var/lib/mysql
scp serverx.serverdomain.com:/var/lib/mysql/filename.tgz ./

[ enter password ]

tar -zxvf filename.tgz

Done.


Posted in Windows. Bookmark the permalink.