James, ----- Original Message ----- From: "James Kelty" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, October 04, 2002 12:13 AM Subject: Slave server and InnoDB
> sql,query > > Hello. > > Is there an option for the slave server to NOT stop when an error > inducing query is run on the master? > > For instance, if someone tries in insert a duplicate entry, and the > master shows the error, but updates the binlog, how can I keep the slave > from seeing the same error, and NOT stopping itself? only successful queries are written to the binlog and replicated. It is a bug in MySQL replication if a duplicate key error in the master is propagated to the slave. > Thanks! > > > -James Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com --------------------------------------------------------------------- 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
