//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.
The first username and password are for the remote database and the last ones are for your local database.
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.
Comments
Add your comment
No Comments