Hello mysql, I'm using mysql 3.23.47 with Innodb and trying to play around with replication. The replication options are default.
I got one table content occasionally deleted on slave, and note what this did not stop the replication: The inserts are successfully passed, therefore the updates to nonexistent rows simply ignored. I remember then I tried this half a year ago with myisam, the behavior was to print an error and stop. SLAVE: mysql> select count(*) from counter.quickstat; +----------+ | count(*) | +----------+ | 661 | +----------+ 1 row in set (0.04 sec) MASTER: mysql> select count(*) from counter.quickstat; +----------+ | count(*) | +----------+ | 294787 | +----------+ 1 row in set (2.65 sec) -- Best regards, Peter mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
