1. have one (or more) slave readonly and don't give the developer the
2. have another slave for him to play with.
3. when you need to clean up his mess, stop the readonly slave, take a
dump, copy to playpen, start up both.
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Shanmugam, Dhandapani [mailto:dhandapani.shanmugam@stripped]
> Sent: Friday, May 16, 2008 12:14 AM
> To: replication@stripped
> Cc: mysql@stripped
> Subject: Slave Server
> Hi There,
> I am setting up a replication with one master and one slave.
> I have created two databases in Master Server and it gets
> replicated to
> the slave. When developer do changes on the slave database,
> It will not
> be sync with the Master server. My requirement is when ever
> developer do
> changes in the slave database. I need to revert backup to the Master
> server. How this is possible. Thanks in Advance
> Thanks and Regards,
|• Slave Server||Dhandapani Shanmugam||16 May|
| • RE: Slave Server||Rick James||16 May|