Hello Heikki, Saturday, January 05, 2002, 11:55:02 PM, you wrote:
>>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 HT> Who deleted the table contents? You? Yes. I did it. >> this did not stop the replication: The inserts are successfully >> passed, therefore the updates to nonexistent rows simply ignored. HT> But MySQL passes complete SQL statements to the slave. It is no error if an HT> update does not update any rows. I do not believe that MySQL checks that the HT> master updated as many rows as the slave. May be this is the problem, because for example for insert mysql check if it was able to insert data (no duplicates or what ever) but this does not work with updates. >> I remember then I tried this half a year ago with myisam, the >> behavior was to print an error and stop. >> Well probably I'm a bit mistaken - the error is checked for insert because duplicate key error is an error, therefore the update which does not update anything is quite OK. -- 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