Syncing remote database to local?

Question

I'm hoping I can use a shell script that will pull a sql dump down from my production site and into my local database. Ideally, I'd like to be able to run something like this:

sync_site example_com example_local

Where the first argument is the production database and the second is the local database. The remote database is always on the same server, behind SSH, with known MySQL credentials.

hexacyanide · Accepted Answer · 2014-07-16 04:26:59Z

12

Figured it out:

ssh [email protected] mysqldump -u user -ppass remote_db | mysql -u user -ppass local_db

edited Jul 16, 2014 at 4:26

hexacyanide

92.4k31 gold badges168 silver badges162 bronze badges

answered Feb 3, 2011 at 20:07

aaron carlino

3133 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sghael Over a year ago

You can make it faster by piping it through compression. Assuming you have bzip on both ends:

ssh [email protected] "mysqldump -u username -ppassword remote_db --verbose | bzip2 -c" | bunzip2 -c | mysql -u localuser -plocalpass localdb

tw16 Over a year ago

Don't forget you should Accept your own answer. Clearly it has helped others.

Collectives™ on Stack Overflow

Syncing remote database to local?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related