Hi Martin, Replication definitely does not ignore CREATE DATABASE all the time, just every now and then :) I had 93 databases that made it through replication, and the 94th failed. There aren't any binlog-ignore-db paramaters. I've dumped the binlog out, and CREATE DATABASE did make it into the log, and the slave did make it past that point without creating the database.
Is there any reason to think that replication is more reliable in the 4.0 series? David On Wed, Jan 15, 2003 at 02:39:34PM +0000, Martin Waite wrote: > - sql,query > > On Tue, 2003-01-14 at 23:55, Jeremy Zawodny wrote: > > > > What do the relevant sections of the my.cnf files on the master and > > slave look like? > > -- > > Hi, > > I've had the same issue - but always assumed that > replication was meant to ignore "create database ...". > > I've looked into it further, and it looks like if > you have any "binlog-ignore-db" directives in the > master's my.cnf file then "create database" commands > are not routed to the binlog. > > == > Martin > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
