Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Viewing Log File with "mysqlbinlog"

By: FYIcenter.com

(Continued from previous topic...)

How To Use mysqlbinlog to View Binary Logs?

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*/;

(Continued on next topic...)

  1. What Is the MySQL Server Daemon - mysqld?
  2. What Are the "mysqld" Command Line Options?
  3. How To Start MySQL Server Daemon mysqld?
  4. How To Properly Shutdown MySQL Server Daemon mysqld?
  5. How Much Memory Does the Server Take?
  6. How To Turn on Query Logs?
  7. How To Turn on Error Logs?
  8. What Is Binary Log File?
  9. How To Turn on Binary Logs?
  10. How To Use mysqlbinlog to View Binary Logs?
  11. How To Run MySQL Server on a Different Port?
  12. How To Connect to MySQL Server on a Different Port?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...