0

I am using Mysql 5.7 and 2-days back someone drop my table. I didn't enable my general log. How can i find the username who dropped the table?

3
  • Welcome to the site , By default, the server writes files for all enabled logs in the data directory. Did you checked that. Feb 26, 2018 at 6:41
  • Did you have the binlog turned on?
    – Rick James
    Mar 3, 2018 at 23:35
  • yes. Its configure for replication.
    – Irfi
    Mar 6, 2018 at 9:37

1 Answer 1

0

By default MySQL doesnot log general SQL statements. Configure MySQL to do so. The MySQL documentation on logging (MySQL :: MySQL 5.1 Reference Manual :: 5.2 MySQL Server Logs) should help you do that.

1
  • Unfortunately, i didn't enable general log when the table was dropped. From which server logs i can get my desired information
    – Irfi
    Feb 27, 2018 at 4:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.