2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
9
CREATE TABLE t1 (b CHAR(10));
15
LOAD DATA INFILE FILENAME
16
SELECT COUNT(*) FROM t1;
19
show binlog events from <binlog_start>;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (b CHAR(10))
22
master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
23
master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/rpl_bug12691.dat' INTO TABLE `t1` FIELDS TERMINATED BY '|' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`b`) ;file_id=#
26
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
28
SELECT COUNT(*) FROM t1;