mysql 灾难恢复_mysql灾难恢复

数据库中的某个表被意外清空，且有以前某个时间的备份文件时，数据恢复的方法。下面是演示过程。

1、查看现有表内容

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| mytest |

| performance_schema |

| test |

+--------------------+

5 rows in set (0.34 sec)

mysql> use mytest;

Database changed

mysql> select * from user;

+------+-------+

| id | name |

+------+-------+

| 1 | test |

| 2 | test2 |

+------+-------+

2 rows in set (0.01 sec)

2、插入新数据

mysql> insert into user values(3,'new');

Query OK, 1 row affected (0.01 sec)

mysql> insert into user values(4,'new1');

Query OK, 1 row mysql> select * from user;

+------+-------+

| id | name |

+------+-------+

| 1 | test |

| 2 | test2 |

| 3 | new |

| 4 | new1 |

+------+-------+

4 rows in set (0.00 sec)affected (0.01 sec)

3、删除表

mysql> drop table user;

Query OK, 0 rows affected (0.03 sec)