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.

Answers


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?


Need Your Help

Iterate through table rows with for loop

javascript jquery html for-loop

I'm using jquery each loop to loop through rows in the table, if there is a row that already exists with the attribute data-prd-id then i will hide it, I successfully did it however, as I know the ...

How to replace a text pattern containing brackets?

search sed replace

I want to replace a specific instruction containing brackets with another instruction recursively in all the files.