<div>
Have you enabled server logging so that you see what delete commands are being executed.<br />
Is it possible that deleted commands are being executed on the table but not using PK information?<br />
Have you noticed any unexpected logins to the server?<br />
Are you sanitising user input and using Paramters when executing commands?
</div>


<div>
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.
</div>


<div>
As a rule Data doesn't disappear!<br />
Normally it's a case of a user changing some detail, that makes it not part of the Dataset.<br />
<br />
Gary
</div>


<div>
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!
</div>


<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

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?

I don&#39;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.

As a rule Data doesn&#39;t disappear!
Normally it&#39;s a case of a user changing some detail, that makes it not part of the Dataset.

Gary

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!

Data randomly disappears from on mysql table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.