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?