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, 7670👍, 0💬
Popular Posts:
How can JavaScript make a Web site easier to use? That is, are there certain JavaScript techniques t...
How Many Tags Are Defined in HTML 4.01? There are 77 tags defined in HTML 4.01: a abbr acronym addre...
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
Can each Java object keep track of all the threads that want to exclusively access to it?
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...