MySQL & Data Loss

[magic-chef]

I have a MySQL DB that seems to be losing ALL of the data in random tables. Only one or two tables are affected. This has only happened twice so far. Any one hear of this?

[trooper]

Give us some more information about the problem

THe more you can give us the better

GM

[superwormy]

Does it just vanish? Do the tables crash? What version of MySQL / PHP / OS?

Are you sure you don't have any DELETE FROM table WHERE field LIKE '%$my_uncheck_variable_that_someone_left_blank%' queries?

[magic-chef]

PHP v. 4.2.3
MySQL v. 3.23.39
Red Hat Linux

The table structure is intact. Only data is missing.

I do not use checkboxex for deletes. Instead I use single record delete actions.

This info is coming from the admin of the site who says all information disappeared from two tables. I checked the tables with phpMyAdmin and they were indeed empty.

If there is anymore info you need let know and thanks for the time.

[trooper]

Hmmm get admin to verify that it was indeed there in the first place

GM

[magic-chef]

It was there. I had viewed in the afternoon. The loss happened overnight.

[superwormy]

Start logging every query in yoru application, log each one to a text file, and log the mysql_num_rows() result as well, then you can see how many rows were affected / deleted.

Find out if its your application or something else.

Oh, and keep good backups :-)

Schedule cron to make a new backup ( ie not overwrite the old one ) every hour or something.