php - How to keep two MySQL databases in sync?

Question

Is there a way to keep two databases in sync? I have a client who's running WordPress with MySQL. Is there a way to take a copy of the database the current state, and use it for a development server, and then when the dev changes are done push it back to the live site?

The client might make changes to the live site while I'll be working on the dev version, and wondering if there will any merge conflicts.

If I import the updated database via phpmyadmin, will it only update with only the newest changes or overwrite everything?

Answer 1

Here's a quick reference of MySQL Replication by @Mark Baker or you can use MySQL Workbench Synchronization.