Add the following line to you slave my.cnf file: replicate-ignore-db=mysql >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/16/04, 2:44:53 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Re: Blocking INSERT/UPDATE on SLAVE (replication): > I'm currently replicating all databases, so this would happen. > This means that I should change my setup to do not replicate the 'mysql' > database. > Is there a way to explicity do not replicate only 'mysql' and replicate all > others, including new databases? > []s, > Conrado > ----- Original Message ----- > From: "Alan Williamson" <[EMAIL PROTECTED]> > To: "cvarda" <[EMAIL PROTECTED]> > Sent: Tuesday, March 16, 2004 5:30 PM > Subject: Re: Blocking INSERT/UPDATE on SLAVE (replication) > > > > > > cvarda wrote: > > > > > But this wouldn't conflict with 'mysql' database replication? Changes on > the > > > master users would override my setup on the slave... am I wrong? > > > > > > yes you are wrong :) > > > > you only mirror/replicate certain DATABASES, not the whole server. > > Therefore you wouldn't not mirror the 'mysql' database as this would > > then cause the problems you describe. Only mirror the database with > > your real data > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]