Hi Fred, thanks for reply.
But we want to replicate the mysql database... we want a exact copy of the
Is there another way?
----- Original Message -----
From: "Fred van Engen" <fred.van.engen@stripped>
To: "Eduardo D Piovesam" <eduardo@stripped>
Sent: Wednesday, December 03, 2003 10:32 AM
Subject: Re: Replication : blocking updates to slave
> On Wed, Dec 03, 2003 at 10:25:28AM -0200, Eduardo D Piovesam wrote:
> > We're using replication (1 master + 1 slave), and we want to block
> > deletes, issued by the users, to the slave.
> > Because sometimes they get confused and use the slave as the master...
> > it?
> Give their account different GRANTs on the master than on the slave(s)
> and make sure that GRANTs (the `mysql` database) are not replicated from
> the master to the slaves.
> Fred van Engen XB Networks B.V.
> email: fred.van.engen@stripped Televisieweg 2
> tel: +31 36 5462400 1322 AC Almere
> fax: +31 36 5462424 The Netherlands