MySQL Forums
Forum List  »  Newbie

Wht deleted the rows
Posted by: Kieran Kelly
Date: February 22, 2023 02:59AM

Hi, I have a table and noticed that rows got deleted from it. I created a BEFORE DELETE trigger and logged the reuslts into another table. It happened in September and again at the end of January this year. The timing doesn't coincide with any of the scripts that I have running and I've quickly checked logs to see what was actually at the itme and can find nothing.

I have two questions.

1. Is it possible to find out exactly what was running at the time that might have caused this?

2. Is it possible to track or record the name of the process or script even the SQL statement that did the deletion, so that if it happens again, I might have more info?

Only some rows were deleted (quite a few, but not all)

Thanks in advance.


Options: ReplyQuote

Written By
Wht deleted the rows
February 22, 2023 02:59AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.