One of the more frustrating things for me working with mySQL (even though on a daily basis I love it) is copying tables between production, test and development on my laptop. Well I figured it out today and thought I would share.

Here’s the code:

mysqldump -u [username] -p [password] [database_name] [table(s)] | mysql --compress -h [server_destination] -u [username] -p [password] [database_destination]

This is run from the mysql server you wish to copy data from. this is all on one line in *nix.