Digital Marketing

mysqlbinlog - Utility for Processing Binary Log Files for MySQL

MySQL server's binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay log files written by a slave server in a replication setup because relay logs have the same format as binary logs.

Example usage:

mysqlbinlog mysql-bin.000212 --start-position=589388355 | mysql  --login-path=db5

mysqlbinlog binlog.0000088 --start-datetime="2015-08-08 18:08:08" | mysql --login-path=db5 --force

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

Creating sort index in MySQL

How to fix: df shows no file systems processed on Linux