Last Updated: February 25, 2016
·
437
· arthurbarros

Copy MySQL tables between hosts in one line

#mysql
 
mysqldump -h ip -u user -p pass from_database from_table | mysql -u user -p pass target_database

Enjoy.

#mysql

Written by Arthur Barros

Say Thanks
Respond

Related protips

Uninstall all those broken versions of MySQL and re-install it with Brew on Mac Mavericks

329.5K
46

Splitting Strings with MySQL

316.5K
0

SOLVED: Can't connect to local mySQL server through socket /tmp/mysql.sock

122.1K
9

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Mysql Authors
corysimmons
328.9K
#mysql
#HTML
#CSS
fstrube
316.4K
#mysql
#PHP
#Linux
timfernihough
129.8K
#mysql
#mamp
#unix
nicolaskempfpro
108.4K
#mysql
#javascript
#HTML
groodt
82.3K
#mysql
#Python
#Open Source
Related Tags
#mysql
Sponsored by
#native_company#
#native_desc#
#native_cta#
Awesome Job
See All Jobs
Post a job for only $299
Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#