jayaneetha jayaneetha - 5 months ago 41
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


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 !