MySQL Forums
Forum List  »  MyISAM

Re: Disappearing rows
Posted by: Hsing-Tsu Lai
Date: September 03, 2006 01:14AM

binlog does not log any "select", for example.

If auto_comment is off or comments are controlled by the client c program, then it's possible that killing the client proc results in lost of data.

Do you have replication going? if so, it would be good to check if the missing data are on the slave server, if all update actions are recorded in the binlogs.

bugs? It's always possible. But, then it would be helpful if you can create an easily reproducible case.

Options: ReplyQuote


Subject
Views
Written By
Posted
2385
September 01, 2006 03:22AM
1574
September 02, 2006 02:53AM
1653
September 02, 2006 09:42PM
Re: Disappearing rows
1682
September 03, 2006 01:14AM
2064
October 04, 2006 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.