Searching MySQL Bin Log for a Query

mysql binlog mysqlbinlog
David picture David · Oct 8, 2010 · Viewed 16.2k times · Source

Is it possible to query the mysql bin log for a particular query? For example, suppose I want to know if anyone in the last hour did a specific query (like 'Update tableX where userName = 'bob'"). I just want to see if a particular query has been run recently.....

Answer

baklarz2048 picture baklarz2048 · Oct 8, 2010

Use mysqlbinlog - nix or mysqlbinlog.exe - windows

$bash>mysqlbinlog mysql_bin.log > mysql_bin.txt

After conversion You can search DML in mysql_bin.txt

Related questions

What is binlog in mysql?

I've set mysql parameter innodb_flush_log_at_trx_commit=0. It means that mysql flushes transactions to HDD 1 time per second. Is it true that if mysql will fail with this flush (because of power off) i will lose my …

Read More
MySQL Binary Log Replication: Can it be set to ignore errors?

I'm running a master-slave MySQL binary log replication system (phew!) that, for some data, is not in sync (meaning, the master holds more data than the slave). But the slave stops very frequently on the slightest MySQL error, can this …

Read More
MySQL - Is there a way to include the bin log position in the dump file without scripting

Is there a way to include the replication bin log position in the dump file without scripting? I know there are ways through scripting, appending a line to the dump file etc. But I remember once reading that it's possible …

Read More