Moving data between mysql hosts
Posted by Jamsi in Linux on November 20th, 2006 | no responses
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 dbNAMEDid you like this? Share it:
No related posts.