Use one or the other, not both, of -do- and -ignore-.
Rick James
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Thomas [mailto:tja@stripped]
> Sent: Wednesday, January 28, 2009 3:33 PM
> To: Jeremy@stripped
> Cc: replication@stripped
> Subject: Re: Replication of certain databases only?
>
> Hello Jeremy,
> thanx for your reply!
>
> I already used line like this in my.cnf:
>
> binlog-do-db=<db>
> binlog-do-db=<db>
>
> binlog-ignore-db=<db>
> binlog-ignore-db=<db>
>
>
> But to get the slave up to the latest status, i used "load data from
> master;" - and then, ALL databases got copied!
>
>
> I try to use the following then:
>
> mysqldump --password=<PW> --opt --delete-master-logs
> --single-transaction --flush-logs --master-data=1 --databases ${db} >
> mysqldump_${db}_NEW
> cat mysqldump_${db}_NEW | ssh slave "cat | mysql"
> ssh slave
> mysql ${db}
> show slave status; // Which looks OK!
> start slave;
> show slave status;
>
> The result are errors like this:
>
> Error 'Table 'my_database.ibf_sessions' doesn't exist' on
> query. Default
> database
>
> This is a complete different database!
>
> Also, "grep my_database mysqldump_${db}_NEW2 does NOT show
> such entries
> in the database to be replicated.
>
> It seems, the slave just get´s more data in the binary logs that it
> should get!
>
> And this is, why i ask here :)
>
> It seems, the binlog-ignore-db just does not work!
>
> Any idea?
>
> :-O
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>