DEV Community

Akabwai-samuel
Akabwai-samuel

Posted on

Synchronizing local mysql database with remote one with a script or automatically?

Synchronizing local mysql database with remote one with a script or automatically?
Any help will be appreciated

Top comments (2)

Collapse
 
kant312 profile image
Quentin Delcourt

I did a script for that, some time ago. You can find it here:
github.com/Tcheu/tcheu-scripts/tre...

It basically connects to the remote server via SSH, creates a dump of the database and import it locally.

Depending on the size of your remote DB, it might be interesting to compress the dump on the server before downloading it, but that's something missing from my script unfortunately :s

Collapse
 
akabwaisamuel profile image
Akabwai-samuel

Okay thanks let me check it out