From: Geoff Galitz
Date: March 11 2011 7:55am
Subject: Re: Table Records Deleted by anonymous user!
List-Archive: http://lists.mysql.com/mysql/224619
Message-Id: <35BBBB90F6774229B39A7B9671C0DC43@USERPC>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="UTF-8";
	reply-type=original
Content-Transfer-Encoding: 7bit

>> say that it is done intentionally but could not point anyone because
>> we did not enable the logging feature in MySQL.
>
> You already said it yourself: you don't have logging enabled, so that data 
> is not available.
>
> If you have binary logs, you could comb through those for the delete 
> statements; that'll at least give you a timeframe.
>


I would also go through the logs of whatever other entry vectors exist to 
your database (apache, for example) for suspect looking statements or 
logins.  Also I'd check the history files such as .mysql_history and "last" 
on the database server to look for anything suspicious.

Is it possible there is filesystem corruption which is actually responsible? 
Take the server offline and run standard diagnostics such as fsck, perhaps.