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, 7350👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=20,y=35; x=y++ + x++; y= +...
How can I implement a variable field width with printf? That is, instead of something like %8d, I wa...
.NET INTERVIEW QUESTIONS - What is the difference between thread and process? A thread is a path of ...
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...
What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...