Data randomly disappears from on mysql table

I have a mysql database that I have had data disappear from randomly. The odd thing is it only happens with 1 table. All other tables in database are fine. Any ideas what might cause this?
deanx032Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ee_autoConnect With a Mentor Commented:
Question PAQ'd, 500 points refunded, and stored in the solution database.
0
 
oobaylyCommented:
Have you enabled server logging so that you see what delete commands are being executed.
Is it possible that deleted commands are being executed on the table but not using PK information?
Have you noticed any unexpected logins to the server?
Are you sanitising user input and using Paramters when executing commands?
0
 
deanx032Author Commented:
I don't know the answers to any of those questions. I will try to find them and get back to you. I went through all of the logs I have access to and was not able to identify any suspicious logins. Of course, that might just be the ftp and not the database.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
tbsgadiCommented:
As a rule Data doesn't disappear!
Normally it's a case of a user changing some detail, that makes it not part of the Dataset.

Gary
0
 
tbsgadiCommented:
As a rule Data doesn't disappear!
Normally it's a case of a user changing some detail, that makes it not part of the Dataset.

Gary
0
 
deanx032Author Commented:
The problem has been solved. The site had been hacked into because I had forgotten to put access restrictions on one of the delete pages. Thanks for your input everyone!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.