从mysqldump全备中恢复指定表数据
需求:当需要从全备份中恢复单个表,怎么办?
测试前准备
(1).mysqldump备份指定数据库,如:dbtest
[mysql@test]$ mysqldump -uroot -p mysql -F -R -E --triggers --databases dbtest | gzip >dbtest_$(date +%F).sql.gz
(2).确认备份文件已经生成
[mysql@test]$ ll dbtest*
dbtest_2016-11-07.sql.gz
(3).模拟删除auto表
mysql> show tables;
+---------------+
| Tables_in_dbtest |
+---------------+
| ab |
| dst |
+---------------+
2 rows in set (0.00 sec)
mysql> select * from ab;
+----+------+
| id | name |
+----+------+
| 1 | a |
| 2 | b |
| 4 | c |
+----+------+
3 rows in set (0.00 sec)
mysql> drop table