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, 7459👍, 0💬
Popular Posts:
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
.NET INTERVIEW QUESTIONS - What are Daemon threads and how can a thread be created as Daemon? Daemon...
How To Compile a JUnit Test Class? Compiling a JUnit test class is like compiling any other Java cla...
.NET INTERVIEW QUESTIONS - Where do you specify session state mode in ASP.NET ? The following code e...
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL Transaction iso...