Collections:
Viewing Log File with "mysqlbinlog" in MySQL
How To Use mysqlbinlog to View Binary Logs in MySQL?
✍: FYIcenter.com
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
2017-11-29, 1434🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...