jayaneetha jayaneetha - 1 year ago 109
SQL Question

Sync Local Database data to a remote Database

I'm having a system which runs online. I have to make that system run in localhost. But the original online system should be updated once a day. Anyone know about a tool which can transfer the local database data to the remote database which is MySQL

Answer Source

Use the mysqldump that is a native mysql tool to create a dump from your database and restore it on the other side ! (but this depends on your database size)
Or you can use replication with a delay window!
For how to replicate your MySQL database follow this article here !

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download