How To Use mysqlbinlog to View Binary Logs in MySQL?

If you have binary logs turned on, you can use "mysqlbinlog" to view the binary log files. The tutorial exercise below shows you how to view two binary files together:

>cd \mysql\bin
>mysql -u root -pretneciyf test

>mysqlbinlog ..\logs\binary.000001 ..\logs\binary.000002
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,
 COMPLETION_TYPE=0*/;
# at 4
# server id 1  end_log_pos 98    Start: binlog v 4, 
ROLLBACK;
# at 98
#20:35:34 server id 1  end_log_pos 184   Query   thread_id=1
SET TIMESTAMP=1156530934;
SET @@session.foreign_key_checks=1, 
@@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
/*!\C latin1 */;
SET @@session.character_set_client=8,
@@session.collation_connection=8,
@@session.collation_server=8;
REVOKE DROP ON *.* FROM DEV;
# at 184
#20:36:02 server id 1  end_log_pos 203   Stop
# at 4
#20:36:06 server id 1  end_log_pos 98    Start: binlog v 4,
# Warning: this binlog was not closed properly. 
# Most probably mysqld crashed writing it.
ROLLBACK;
# at 98
#20:37:08 server id 1  end_log_pos 176   Query   thread_id=1
use test;
SET TIMESTAMP=1156545428;
SET @@session.foreign_key_checks=1, 
@@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
/*!\C latin1 */;
SET @@session.character_set_client=8,
@@session.collation_connection=8,
@@session.collation_server=8;
drop table test;
# at 176
#20:37:35 server id 1  end_log_pos 275   Query   thread_id=1
SET TIMESTAMP=1156545455;
create table test (name varchar(80));
# at 275
#20:38:00 server id 1  end_log_pos 383   Query   thread_id=1
SET TIMESTAMP=1156545480;
insert into test values ('dba.fyicenter.com');
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

⇒ Running MySQL Server on a Specific Port in MySQL

⇐ Turn on Binary Logs in MySQL

⇑ Server Daemon mysqld Administration in MySQL

⇑⇑ MySQL Database Tutorials