Moving data between mysql hosts

By Jamsi • Nov 20th, 2006 • Category: Linux

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

Related posts:

  1. Using Knoppix for data retrieval
  2. MySQL error #1135: Can’t create a new thread (errno 11).


FREE NEWSLETTER -> Want Tech Tips Sent Straight to your Inbox?

Grab our Newsletter to Ensure your PC is Running Smooth!

Jamsi is currently studying a full time Bachelor of Computer/Business degree and working part time as an Internet Security Consultant.
Email this author | All posts by Jamsi

Leave a Reply