Applying binary logs without adding to the binary log
Posted by Sheeri Cabral on Feb 25, 2010
Applying binary logs to a MySQL instance is not particularly difficult, using the mysqlbinlog command line utility:
$> mysqlbinlog mysql-bin.000003 > 03.sql $> mysql < 03.sql
Turning off binary logging for a session is not difficult, from the MySQL commandline, if you authenticate as a user with the SUPER privilege:
mysql> SET SESSION sql_log_bin=0;
However, sometimes you want to apply binary logs to a MySQL instance, without having those changes applied to the binary logs themselves. One option is to restart the server binary logging disabled, and after the load is finished, restart the server with binary logging re-enabled. This is not always possible nor desirable, so there’s a better way, that works in at least versions 4.1 and up:
Read the rest of this entry . . .
