/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #100629 13:22:27 server id 1 end_log_pos 106 Start: binlog v 4, server v 5.1.47-community-log created 100629 13:22:27 BINLOG ' A1YqTA8BAAAAZgAAAGoAAAAAAAQANS4xLjQ3LWNvbW11bml0eS1sb2cAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC '/*!*/; # at 106 #100629 13:22:27 server id 1 end_log_pos 197 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; SET @@session.pseudo_thread_id=16/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; DROP DATABASE IF EXISTS test /*!*/; # at 197 #100629 13:22:27 server id 1 end_log_pos 280 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; CREATE DATABASE test /*!*/; # at 280 #100629 13:22:27 server id 1 end_log_pos 366 Query thread_id=16 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1277842947/*!*/; SET @@session.foreign_key_checks=0/*!*/; DROP TABLE IF EXISTS t1 /*!*/; # at 366 #100629 13:22:27 server id 1 end_log_pos 519 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; CREATE TABLE t1 (a INT, INDEX a_idx (a), FOREIGN KEY (a) REFERENCES t3(a)) ENGINE = InnoDB /*!*/; # at 519 #100629 13:22:27 server id 1 end_log_pos 587 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; BEGIN /*!*/; # at 587 # at 628 #100629 13:22:27 server id 1 end_log_pos 628 Table_map: `test`.`t1` mapped to number 1524 #100629 13:22:27 server id 1 end_log_pos 662 Write_rows: table id 1524 flags: STMT_END_F BINLOG ' A1YqTBMBAAAAKQAAAHQCAAAAAPQFAAAAAAEABHRlc3QAAnQxAAEDAAE= A1YqTBcBAAAAIgAAAJYCAAAQAPQFAAAAAAMAAf/+AQAAAA== '/*!*/; # at 662 #100629 13:22:27 server id 1 end_log_pos 689 Xid = 15160 COMMIT/*!*/; # at 689 #100629 13:22:27 server id 1 end_log_pos 775 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; DROP TABLE IF EXISTS t2 /*!*/; # at 775 #100629 13:22:27 server id 1 end_log_pos 928 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1277842947/*!*/; CREATE TABLE t2 (a INT, INDEX a_idx (a), FOREIGN KEY (a) REFERENCES t3(a)) ENGINE = InnoDB /*!*/; # at 928 #100629 13:22:27 server id 1 end_log_pos 980 Rotate to US-TF221715-02-bin.000023 pos: 4 DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;