MySQL records being deleted, and I don't know why
I have a serious problem of records being deleted automatically from a specific table in my MySQL database.
After I figured that, I started to check the MySQL binary log to discover what was happening.
Seems that without standard appears DELETE commands, an example of the LOG transcribed below:
# at 454 #120605 15:37:48 server id 1 end_log_pos 570 Query thread_id=59 exec_time=0 error_code=0 SET TIMESTAMP=1338921468/*!*/; DELETE FROM intranet_cadeira2 WHERE idCadeira='59' /*!*/; # at 570 #120605 15:40:15 server id 1 end_log_pos 686 Query thread_id=66 exec_time=0 error_code=0 SET TIMESTAMP=1338921615/*!*/; DELETE FROM intranet_cadeira2 WHERE idCadeira='29' /*!*/;
The data is inserted correctly, the procedure that inserts data in the tables is the following:
BEGIN INSERT INTO intranet_cadeira2 (idIntranet,titulo) VALUES (pidIntranet,ptitulo); COMMIT; END
But after a while the records are deleted one by one. I'm racking my brain for it, I appreciate if anyone can help! I'm pretty sure that it's not a security problem.
I don't think it is possible to see the cause from your codes. However, I believe there is a timeout and delete. And maybe once the files get expired, they get deleted from the records.
Also, is it in local server or not?