[mysql@Mserver1 binlog]$ mysqlbinlog mysql.000009
。。。。。
use `ttt`/*!*/;
SET TIMESTAMP=1446690281/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C gbk *//*!*/;
SET @@session.character_set_client=28,@@session.collation_connection=28,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
create table t1 as select * from mysql.user
/*!*/;
# at 241
#151105 10:39:57 server id 1 end_log_pos 365 CRC32 0x0bd0f504 Query thread_id=8 exec_time=0 error_code=0
SET TIMESTAMP=1446691197/*!*/;
SET @@session.sql_mode=0/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
DROP TABLE IF EXISTS `pet` /* generated by server */
/*!*/;
# at 365
#151105 10:39:57 server id 1 end_log_pos 690 CRC32 0xef9ecc5c Query thread_id=8 exec_time=0 error_code=0
SET TIMESTAMP=1446691197/*!*/;
CREATE TABLE `pet` (
`name` varchar(20) DEFAULT NULL,
`owner` varchar(20) DEFAULT NULL,
`species` varchar(20) DEFAULT NULL,
`sex` char(1) DEFAULT NULL,
`birth` date DEFAULT NULL,
`death` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
/*!*/;
# at 690
#151105 10:40:52 server id 1 end_log_pos 789 CRC32 0xc86ab530 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1446691252/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
/*!\C gbk *//*!*/;
SET @@session.character_set_client=28,@@session.collation_connection=28,@@session.collation_server=33/*!*/;
alter table pet charset=gbk
/*!*/;
# at 789
#151105 10:43:16 server id 1 end_log_pos 860 CRC32 0x5375e3d6 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1446691396/*!*/;
BEGIN
/*!*/;
# at 860
#151105 10:43:16 server id 1 end_log_pos 918 CRC32 0xd4b20f74 Table_map: `ttt`.`pet` mapped to number 84
# at 918
#151105 10:43:16 server id 1 end_log_pos 1166 CRC32 0xe28d079a Write_rows: table id 84 flags: STMT_END_F
BINLOG '
RMI6VhMBAAAAOgAAAJYDAAAAAFQAAAAAAAEAA3R0dAADcGV0AAYPDw/+CgoIPAA8ADwA/gM/dA+y
1A==
RMI6Vh4BAAAA+AAAAI4EAAAAAFQAAAAAAAEAAgAG/+AGRmx1ZmZ5Bkhhcm9sZANjYXQBZkSSD+AF
Q2xhd3MER3dlbgNjYXQBbXGUD+AFQnVmZnkGSGFyb2xkA2RvZwFmrYoP4ARGYW5nBUJlbm55A2Rv
ZwFtG40PwAZCb3dzZXIFRGlhbmUDZG9nAW0fdw/9lg/gBkNoaXJweQRHd2VuBGJpcmQBZiudD+gI
V2hpc3RsZXIER3dlbgRiaXJkiZsP4ARTbGltBUJlbm55BXNuYWtlAW2dmA/gCFB1ZmZiYWxsBURp
YW5lB2hhbXN0ZXIBZn6eD5oHjeI=
'/*!*/;
# at 1166
#151105 10:43:16 server id 1 end_log_pos 1197 CRC32 0x204c3e04 Xid = 579
COMMIT/*!*/;
# at 1197
#151105 14:21:41 server id 1 end_log_pos 1220 CRC32 0xb95ac86f Stop
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
[mysql@Mserver1 binlog]$
将二进制文件,转成sql文件,再应用
[mysql@Mserver1 binlog]$ mysqlbinlog mysql.000009 > ../../backup/inc_000009.sql
mysql -u ..... < ../../backup/inc_000009.sql
或者直接应用二进制文件
mysqlbinlog mysql.000009 |mysql -u ....