本人新手，自己做实验，使用日志恢复失败，请高手帮忙解答。不胜感激。

kissjiejie

mysql> create database test;
Query OK, 1 row affected (0.16 sec)

mysql> use test
Database changed
mysql> create table t1(id int,name varchar(15));
Query OK, 0 rows affected (0.13 sec)

mysql> insert into t1 values(1,'kk'),(2,'ll');
Query OK, 2 rows affected (0.34 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | kk      |
|    2 | ll        |
+------+------+
2 rows in set (0.00 sec)

D:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin flush-logs

mysql> insert into t1 values(3,'tt');
Query OK, 1 row affected (0.09 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | kk      |
|    2 | ll        |
|    3 | tt       |
+------+------+
3 rows in set (0.00 sec)

D:\Program Files\MySQL\MySQL Server 5.0\bin>mysql --one-database test < ../data/frank-bin.000008
ERROR 1064 (42000) at line 1: 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 '?in欬L' at line 1

strong_sjhi

bin-log 本来是二进制的日志，所以不能直接恢复，应该用工具翻译过来后才可用，如：

mysqlbinlog --start-position=134 --stop-position=330 xxx_binglog.000001 | mysql -uroot -p

andkylee

新手就玩日志恢复， 呵呵! 未来的高手哦。

kissjiejie

回复 2# strong_sjhi


   感谢strong_sjhi兄，试验成功啦~~~
mysql> insert into t1 values(3,'ha');
Query OK, 1 row affected (0.19 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | kk   |
|    2 | ll   |
|    3 | ha   |
+------+------+
3 rows in set (0.00 sec)


D:\Program Files\MySQL\MySQL Server 5.0\bin>mysqlbinlog ../data/frank-bin.000008
|mysql -u root -p
Enter password: ******

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | kk   |
|    2 | ll   |
+------+------+
2 rows in set (0.00 sec)

mysql>

yueliangdao0608

勤动手就是好同志。

ruochen

勤动手就是好同志。
yueliangdao0608 发表于 2010-06-12 10:12

    嗯
自己动动手，碰到问题解决，然后笔记和大家分享