Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Use mysqlbinlog to View Binary Logs
How To Use mysqlbinlog to View Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration
✍: 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*/;
2007-05-11, 7086👍, 0💬
Popular Posts:
How do I debug thread ? This window is only seen when the program is running in debug mode. In windo...
What is the difference between const char* p and char const* p? In const char* p, the character poin...
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to ...
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...
How To Merge Values of Two Arrays into a Single Array? - PHP Script Tips - PHP Built-in Functions fo...