mysql恢复测试报告_mysqldump+mysqlbinlog恢复测试

一、模拟环境

mysql> create database test;

Query OK, 1 row affected (0.02 sec)

mysql> use test;

Database changed

mysql> reset master;

Query OK, 0 rows affected (0.04 sec)

mysql> show binary logs;

+—————–+———–+

| Log_name | File_size |

+—————–+———–+

| mysqlbin.000001 | 107 |

+—————–+———–+

1 row in set (0.00 sec)

mysql> create table t(id int,name varchar(10));

Query OK, 0 rows affected (0.09 sec)

mysql> insert into t values(1,’aaaa’);

Query OK, 1 row affected (0.01 sec)

mysql> insert into t values(2,’bbbb’);

Query OK, 1 row affected (0.00 sec)

二、使用mysqldump备份数据

mysqldump -u root -ppassw0rd –skip-opt –extended-insert=false –master-data=2 –single-transaction –allow-keywords –add-locks –add-drop-table -F -q test &