zhubowen_636
mysqlbinlog增量备份问题
在测试环境中的做增量备份步骤如下:
1. mysqldump -uroot -pxxxx --opt --delete-master-log --all-database --flush-logs > /tmp/bakup.sql (日志文件 mysql-bin.000001 mysql-bin.000002)
2. 用mysql客户端创建一个数据库 (这个操作应该写到mysql-bin.0000002 里面)
3 mysqladmin flush-logs (生成mysql-bin.000003,mysql-bin.0000002应该就是期间的增量备份)
在新的mysql做灾难性恢复
mysql -uroot -p***** < /tmp/bakup.sql
mysqlbinlog mysql-bin.000002
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15
Could not read entry at offset 4:Error in log format or read error
mysqlbinlog -f mysql-bin.000002
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 4
#080603 9:22:05 server id 1 log_pos 98
# Unknown event
# at 98
#080603 9:25:20 server id 1 log_pos 179 Query thread_id=10 exec_time=0 error_code=0
SET TIMESTAMP=1212499520;
@xyzcreate database xyz;
# at 179
#080603 9:25:31 server id 1 log_pos 222 Rotate to mysql-bin.000003 pos: 4
请问一下问题在哪 已经搞两天了....晕死了
[[i] 本帖最后由 zhubowen_636 于 2008-6-3 12:59 编辑 [/i]]