在哪里可以找到MySQL事务日志?
问题描述：
MySQL是否保留事务日志，如果可以，我在哪里可以找到它?
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.
答
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).
但是无论如何，如果您没有在binlog打开之前进行的初始转储，那将毫无用处.另外我想如果您进行转储并打开binlog-您不会问这样的问题:-S
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