在哪里可以找到MySQL事务日志? [英] Where can I find the MySQL transaction log?
本文介绍了在哪里可以找到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
这篇关于在哪里可以找到MySQL事务日志?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文