HostOnNet Blog

HOWTO: Moving MySQL

Looking for Linux Server Admin or WordPress Expert? We can help.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.