Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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?
0
deanx032
Asked:
deanx032
1 Solution
 
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
ee_autoCommented:
Question PAQ'd, 500 points refunded, and stored in the solution database.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now