# at 4397196

#130718 3:17:14 server id 1 end_log_pos 4413603

#Append_block: file_id: 1 block_len: 16384

# at 4413603

#130718 3:17:14 server id 1 end_log_pos 4430010

#Append_block: file_id: 1 block_len: 16384

# at 4430010

#130718 3:17:14 server id 1 end_log_pos 4446417

#Append_block: file_id: 1 block_len: 16384

# at 4446417

#130718 3:17:14 server id 1 end_log_pos 4462824

#Append_block: file_id: 1 block_len: 16384

# at 4462824

#130718 3:17:14 server id 1 end_log_pos 4479231

#Append_block: file_id: 1 block_len: 16384

# at 4479231

#130718 3:17:14 server id 1 end_log_pos 4495638

#Append_block: file_id: 1 block_len: 16384

# at 4495638

#130718 3:17:14 server id 1 end_log_pos 4512045

#Append_block: file_id: 1 block_len: 16384

# at 4512045

#130718 3:17:14 server id 1 end_log_pos 4528452

#Append_block: file_id: 1 block_len: 16384

# at 4528452

#130718 3:17:14 server id 1 end_log_pos 4544859

#Append_block: file_id: 1 block_len: 16384

# at 4544859

#130718 3:17:14 server id 1 end_log_pos 4561266

#Append_block: file_id: 1 block_len: 16384

# at 4561266

#130718 3:17:14 server id 1 end_log_pos 4577673

#Append_block: file_id: 1 block_len: 16384

# at 4577673

#130718 3:17:14 server id 1 end_log_pos 4594080

#Append_block: file_id: 1 block_len: 16384

# at 4594080

#130718 3:17:14 server id 1 end_log_pos 4610487

#Append_block: file_id: 1 block_len: 16384

# at 4610487

#130718 3:17:14 server id 1 end_log_pos 4626894

#Append_block: file_id: 1 block_len: 16384

# at 4626894

#130718 3:17:14 server id 1 end_log_pos 4643301

#Append_block: file_id: 1 block_len: 16384

# at 4643301

#130718 3:17:14 server id 1 end_log_pos 4659708

#Append_block: file_id: 1 block_len: 16384

# at 4659708

#130718 3:17:14 server id 1 end_log_pos 4676115

#Append_block: file_id: 1 block_len: 16384

# at 4676115

#130718 3:17:14 server id 1 end_log_pos 4692522

#Append_block: file_id: 1 block_len: 16384

# at 4692522

#130718 3:17:14 server id 1 end_log_pos 4708929

#Append_block: file_id: 1 block_len: 16384

# at 4708929

#130718 3:17:14 server id 1 end_log_pos 4725336

#Append_block: file_id: 1 block_len: 16384

# at 4725336

#130718 3:17:14 server id 1 end_log_pos 4735417

#Append_block: file_id: 1 block_len: 10058

# at 4735417

#130718 3:17:14 server id 1 end_log_pos 4735701 Execute_load_query thread_id=98119 exec_time=2 error_code=0

SET TIMESTAMP=1374117434/*!*/;

LOAD DATA LOCAL INFILE '/tmp/SQL_LOAD_MB-1-0' INTO TABLE `table` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`c1`, `c2`, `c3`, `

c4`, `c5`, `c6`, `c7`, `c8`, `c9`)

/*!*/;

# file_id: 1

# at 4735701

#130718 3:17:14 server id 1 end_log_pos 4735728 Xid = 297745

COMMIT/*!*/;

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;

/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

确实没有insert之类的sql语句，当用binlog日志进行恢复的时候，会报错的，所以在生产环境上面，最好不要使用load data的方式进行数据导入。以免需要及时恢复数据的时候发生异常。

-- 察看binlog事件,会看到最后的load data local infile纪录.

[sql] view plaincopyprint

mysql> show binlog events in "mysql-bin.000001";

......