Messing with binlogs
Show binlog positions in a log file
mysqlbinlog <log file> | grep log_pos
See if a log file is corrupted
mysqlbinlog <log file> > /dev/null
Create dump file from binlog
mysqlbinlog --start-date="2009-02-20 8:00:00" --stop-date="2009-02-21 8:00:00" \ /var/log/mysql/bin.000001 > /tmp/mysql_restore.sql mysqlbinlog --stop-position="12345" /var/log/mysql/bin.000001 > /tmp/restore.sql mysqlbinlog --start-position="12345" /var/log/mysql/bin.000001 > /tmp/restore.sql
