A table's contents have disappeared!? Was it too big?

[paulmckillop]

One of my MySQL databases has 7 tables in it. By far the largest table had nearly 300,000 records in it, but each record was quite small and the overall file size for the table's .MYD file was only about 18MB. It is running on a Windows 2000 server and the drive is NTFS.

This morning when I went to do a daily backup, I noticed that the table was down to only 1000 odd records, which were all fresg records. So, it looks like the whole table was wiped and it started a fresh overnight. None of the other tables were harmed at all.

There are several server applciations which access the database, but none of them ever delete anything from the database, and only a few have access to the database at all.

Are there any known bugs that would wipe a table under the circumstances described above?

Thank you for your time,
PAUL.

 

[paulmckillop]

More info on the issue above. The table, after the inexplicable disaster of last night, now actually has 1037 records. 973 of them are from 7am this morning until now, which makes sense. But the first 64 records are actually from the birth of the table, 6 weeks ago.

The really strange this is, the records IDs in mysql should jump by about 280,000 between the first 64 records and the last 973, but they don't. The IDs don't skip out any at all.

Just mentioning this in case it should help support any ideas anyone might have of how this all happened.

Cheers,
PAUL.

 

[sleipnir214]

It's not a MySQL table size issue. MySQL can easily handle one or two orders of magnitude more data than you describe.

How are you doing your backups?
How is your database server protected from hostile entities?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[ingresman]

Any clues on dates of the records ?, have your admin guys restored the disk ??