在哪里可以找到MySQL事务日志? [英] Where can I find the MySQL transaction log?

问题描述

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.

推荐答案

如果打开-mysql可以跟踪

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

这篇关于在哪里可以找到MySQL事务日志?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！