Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I find the MySQL transaction log?

Tags:

Does MySQL keep a transaction log and if so where could I find it?

A number of rows have mysteriously been deleted from a table and I want to try and see how and when it occurred.

like image 637
php-b-grader Avatar asked Aug 03 '10 06:08

php-b-grader


1 Answers

If you turned on - mysql can track binary log, which contains all the modifications (to be clear - it contains the queries that had changed something).

But anyway, it is useless if you do not have the initial dump, which precedes the binlog turning on. Also i suppose if you made the dump and turned on binlog - you would not ask such question :-S

like image 77
zerkms Avatar answered Sep 21 '22 11:09

zerkms