How to clone a remote mysql database to a local development machine?

From remote to local
ssh SERVER.ADDRESS.COM -R3307:localhost:3306 \
'mysqldump -uroot --all-databases | mysql -uroot -h127.0.0.1 -P3307'

From remote to local (individual table)
ssh SERVER.ADDRESS.COM -R3307:localhost:3306 \
'mysqldump -uroot DATABASE TABLE | mysql -uroot -h127.0.0.1 -P3307 DATABASE'

From local to remote (individual table)
ssh SERVER.ADDRESS.COM -L3307:localhost:3306
mysqldump -uroot DATABASE TABLE | mysql -uroot -h127.0.0.1 -P3307 DATABASE

Full explanation: StackOverflow

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: