Moving data between mysql hosts

Just something I used today to move a 60Meg table .. something phpMyAdmin refused to import :)

This command will utilize mysqldump to move data between two mysql servers. You need to make sure you have permission to access the SECOND server, either by specifying an access mask or using a wildcard (%) to allow anyone to connect.

mysqldump dbNAME tblNAME --user=root --pass=password | mysql --host=192.168.0.2 --user=root --pass=password -C dbNAME
Did you like this? Share it:

No related posts.



Leave a Reply

You must be logged in to post a comment.