//View Tip #669
Similar Tips
» Migrate MySQL Database to a new Server

 

Latest tips by RSS
Click here to subscribe
Follow Shell-Fu on Twitter
Click here to follow
Follow Shell-Fu on identi.ca
Click here to follow
The following command will allow you to copy a table from the MySQL database on a remote host, to a different MySQL database on your local host.

mysqldump -h [remote IP] -u[user] -p[pass] from_db from_table | mysql -u[user] -p[pass] target_db

The first username and password are for the remote database and the last ones are for your local database.


View Comments »




Comments 

Add your comment

Comments are currently disabled
No Comments

Home Latest Browse Top 25 Random Hall Of Fame Contact Submit