DEV Community

Akabwai-samuel
Akabwai-samuel

Posted on

3

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

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay