090228 13:48:06 server id 1 end_log_pos 106 Start: binlog v 4, server v 5.1.31-community-log created 090228 13:48:06 at startup ROLLBACK/*!*/; BINLOG ' FtCoSQ8BAAAAZgAAAGoAA AAAAAQANS4xLjMxLWNvbW1 1bml0eS1sb2cAAAAAAAAAAA AAAAAAAAAA AAAAAAAA AAAAAAAAAAA W0KhJEzgNAAgAEgAEBAQE EgAAUwAEGggAAAAICAgC'/*!*/;说 BINLOG有语法错误: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BINLOG ' FtCoSQ8BAAAAZgAAAGoAAAAAAAQA NS4xLjMxLWNvb W11bml0eS1sb2cAAAAAAAAAAAAAAA' at line 2
5.9.3. 自动恢复
5.9.3.1. 指定恢复时间
5.9.3.2. 指定恢复位置
mysqlbinlog --stop-date="2009-05-15 16:51:59" E:\MYsql5.1.31\bin\data\mysql-bin.000021 \ |mysql -u root -p*****提示错误:
error line 16, UNKOWN DATABASE ‘qndj’ (即我删除的数据库)
error: writing error 'UNOPENFILE' (errcode :22)
同上
not found "\"
错误信息大致如上
这表示什么意思?
第二步才是:从日志文件中恢复到某时间点 (日志文件中只是改动部分) 当然如果你的日志文件是从创建数据库至今从未PURGE过,则也没问题。
从第一个开始
mysqlbinlog --stop-date="2009-05-15 16:51:59" E:\MYsql5.1.31\bin\data\mysql-bin.000001 \
|mysql -u root -p***** 第一行的没看清楚是什么,后边N行同样的信息:
msqlbinlog:error writing file 'UNOPENED' [errcode:22]...最后一行:
mysqlbinlog:File '\' not found (errcode:2)
然后把几个mysql-bin.000002,003,...0021都生成了,21的时候注意加上 --stop-date="2009-05-15 16:51:59"
另外,你的怎么多写了个
mysqlbinlog --stop-date="2009-05-15 16:51:59" E:\MYsql5.1.31\bin\data\mysql-bin.000001 | mysql -u root -p*****
mysqlbinlog E:\MYsql5.1.31\bin\data\mysql-bin.000002 >> aa.sql
mysqlbinlog E:\MYsql5.1.31\bin\data\mysql-bin.000003 >> aa.sql
....
mysql> source filename
ROLLBACK/*!*/;
BINLOG '
FtCoSQ8BAAAAZgAAAGoAA AAAAAQANS4xLjMxLWNvbW1 1bml0eS1sb2cAAAAAAAAAAA AAAAAAAAAA
AAAAAAAA AAAAAAAAAAA W0KhJEzgNAAgAEgAEBAQE EgAAUwAEGggAAAAICAgC'/*!*/;说 BINLOG有语法错误:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'BINLOG '
FtCoSQ8BAAAAZgAAAGoAAAAAAAQA NS4xLjMxLWNvb W11bml0eS1sb2cAAAAAAAAAAAAAAA' at line 2