MySQL table emptying randomly
Hello
Something very strange has been happening recently
A MySQL table of mine is randomly emptying on me.
Luckily we have a backup of all the data
Any ideas?
The table is very large, thousands of rows
Hello
Something very strange has been happening recently
A MySQL table of mine is randomly emptying on me.
Luckily we have a backup of all the data
Any ideas?
The table is very large, thousands of rows
Mark Hensler posted this at 07:44 — 25th May 2002.
He has: 4,048 posts
Joined: Aug 2000
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.
Wil posted this at 12:48 — 25th May 2002.
They have: 601 posts
Joined: Nov 2001
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/
- wil
Peter J. Boettcher posted this at 13:15 — 28th May 2002.
They have: 812 posts
Joined: Feb 2000
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
PJ | Are we there yet?
pjboettcher.com
mairving posted this at 13:37 — 28th May 2002.
They have: 2,256 posts
Joined: Feb 2001
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?
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
nike_guy_man posted this at 17:15 — 28th May 2002.
They have: 840 posts
Joined: Sep 2000
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
ROB posted this at 16:59 — 6th June 2002.
They have: 447 posts
Joined: Oct 1999
id guess you have a bad query in a script somewhere... like "DELETE FROM tablename" rather than "DELETE FROM tablename WHERE ..."
nike_guy_man posted this at 17:58 — 6th June 2002.
They have: 840 posts
Joined: Sep 2000
It doesn't seem to be doing this anymore...
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.