nike_guy_man — Thu, 06 Jun 2002 17:58:54 +0000

It doesn't seem to be doing this anymore...

ROB — Thu, 06 Jun 2002 16:59:16 +0000

id guess you have a bad query in a script somewhere... like "DELETE FROM tablename" rather than "DELETE FROM tablename WHERE ..."

nike_guy_man — Tue, 28 May 2002 17:15:34 +0000

Peter J B:
1. I am my own host

2. Directory to delete is pass protected, and logs show no other access

3. No automatic delete scripts

4. No other tables

5. Gremlins... hmmm... the cars or the animals??

Mairving:
I've tried from the command line as wella s in a script... same error

The strange thing is that it only happens every few days, and it hasn't happened in 4 days now... let's see

mairving — Tue, 28 May 2002 13:37:17 +0000

Could it be related to this post?

Are you checking the records from a script or by directly accessing the tables? If you are checking it from a script, could it be that some records are excluded?

Peter J. Boettcher — Tue, 28 May 2002 13:15:04 +0000

Tables just don't empty themselves. Check the following:

1. Someone at your hosting company is "accidently" deleting your records.

2. Is there anyone else that works on this database, maybe they are "accidently" deleting records.

3. Do you have any automated queries running that might delete records?

4. Check your relationships. Maybe you have a relationship setup to another table that enforces referential integrity, so when you delete a record out of that table it deletes one or more from this one.

5. Gremlins

Wil — Sat, 25 May 2002 12:48:01 +0000

Maybe your tables are screwed. You might have to repair or rebuild your tables. MySQL has documentation about this on their website => http://www.mysql.com/

Mark Hensler — Sat, 25 May 2002 07:44:14 +0000

I have never heard of that.

*Wild thought*
Check your Apache logs, see if any bots are hitting any admin pages at the time the DB's get emptied.