Q:

Partial sync of Mysql databases on two remote computers

Does mysql replication supports delayed sync if remote slave server is OFF?
For example I want to make my developing server have a fresh copy of databases each morning.
It should be partial sync, not full copy of databases each morning.
And synchronization should be only ONE way, not duplex, to avoid deleting something of master server.
What utilities are out there or native functionality of mysql itself?
Thanks!

A:

You can setup master-slave mysql replication. You can stop the slave whenever you want, and then start it again to make your slave up-to-date. The following mysql commands can be used:
> slave stop;
> slave start;

