Does MySQL keep a transaction log and if so where coudl 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...
Thanks
binary log is enabled - just need to find the file location now...
php-b-grader
2010-08-03 06:59:07
A:
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
zerkms
2010-08-03 06:45:08
I've checked PHPMyAdmin and there are statistics for binary logs which look like they've been running for over 1 week...Is there a config that will point me to the file location (on a linux system)
php-b-grader
2010-08-03 06:58:35
log-bin=mysql-bin -- it is the sample line from my home server config file. so i have mysql-bin* files within my data directory. btw, as i said, if you have no the dump that has been taken just before you turned on binlog - then binlogs are useless. also - you should look at query log (if you have them) as Amber offered.
zerkms
2010-08-03 07:01:56
A:
If you're using MySql on Windows, there's a file located in C:\Program Files\MySQL\MySQL Server 5.0\data (assuming a C: drive for the installation target and MySql version 5.0), that is called %COMPUTERNAME%.log that contains the commands that have been executed.
Rob
2010-08-03 06:48:53