binlog-do-db... says "send only these databases".
replicate-do-db... says "ignore everything but these dbs". Note that
those dbs are all that it will see. So, the replicate-do- is redundant.
(It is also harmless.)
Rick James
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Thomas [mailto:tja@stripped]
> Sent: Monday, February 02, 2009 1:18 PM
> To: Claudio J. Chiabai; replication@stripped
> Subject: Re: Master does not write binary logs!
>
> Claudio J. Chiabai wrote:
> > "Change the slave to new master binlog's "
> >
> > Sorry my english ...
> >
>
> Thanx for your help!
>
> I found the problem!
>
>
> It is the syntax in the my.cnf files!
>
> replicate-do-db=nickdb,usr_web1_1,uwc3
> and
> binlog-do-db=nickdb,usr_web1_1,uwc3
>
> are NOT valid syntax!
>
> After i change to this version, replication is finally running again:
>
> replicate-do-db=nickdb
> replicate-do-db=usr_web1_1
> replicate-do-db=uwc3
>
> binlog-do-db=nickdb
> binlog-do-db=usr_web1_1
> binlog-do-db=uwc3
>
> :)
>
> Now, let?s see if the original problem orrurs again ...
>
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>