MySQL备份与恢复之真实环境使用冷备(三)
mysql-bin.000005 mysql-bin.000010 mysql-bin.000015 serv01.host.com.err
ibdata1 mysql-bin.000001 mysql-bin.000006 mysql-bin.000011 mysql-bin.000016 serv01.host.com.pid
ib_logfile0 mysql-bin.000002 mysql-bin.000007 mysql-bin.000012 mysql-bin.000017 test
#进入数据目录，创建一个文件
[root@serv01 ~]# cd /usr/local/mysql/data/
[root@serv01 data]# touch aa01.txt
#进入快照挂载目录，发现没有这个文件
[root@serv01 mnt]# ls aa01.txt
ls: cannot access aa01.txt: No such file or directory
第十八步，备份数据
[root@serv01 mnt]# cd /databackup/
[root@serv01 databackup]# ll
total 976
-rw-r--r--. 1 root root 995761 Sep 10 17:47 mysql01.tar.gz
[root@serv01 databackup]# /etc/init.d/mysqld status
SUCCESS! MySQL running (2198)
[root@serv01 databackup]# tar -cvzf mysql02.tar.gz /mnt
[root@serv01 mnt]# rm -rf /usr/local/mysql/data/*
[root@serv01 mnt]# /etc/init.d/mysqld stop
ERROR! MySQL server PID file could not be found!
[root@serv01 mnt]# pkill -9 mysql
[root@serv01 mnt]# ps -ef | grep mysqld | grep grep -v
[root@serv01 mnt]# cd /usr/local/mysql/data/
[root@serv01 data]# ll
total 0
第十九步，恢复数据，启动数据库，登录MySQL，然后查看数据是否丢失
[root@serv01 data]# tar -xvf /databackup/mysql02.tar.gz
[root@serv01 data]# ls
mnt
[root@serv01 data]# cd mnt/
[root@serv01 mnt]# mv ./* ../
[root@serv01 mnt]# cd ..
[root@serv01 data]# ls
crm ib_logfile0 mysql mysql-bin.000004 mysql-bin.000008 mysql-bin.000012 mysql-bin.000016 serv01.host.com.err
game ib_logfile1 mysql-bin.000001 mysql-bin.000005 mysql-bin.000009 mysql-bin.000013 mysql-bin.000017 serv01.host.com.pid
hello larrydb mysql-bin.000002 mysql-bin.000006 mysql-bin.000010 mysql-bin.000014 mysql-bin.index test
ibdata1 mnt mysql-bin.000003 mysql-bin.000007 mysql-bin.000011 mysql-bin.000015 performance_schema
[root@serv01 data]# /etc/init.d/mysqld start
Starting MySQL SUCCESS!
[root@serv01 data]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.29-log Source distribution
Copyright (c) 2000, 2012,
Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use larrydb;
Database changed
mysql> select * from class;
+------+--------+
| cid | cname |
+------+--------+
| 1 | linux |
| 2 | oracle |
+------+--------+
2 rows in set (0.00 sec)
mysql> select * from stu;
+------+---------+------+
| sid | sname | cid |
+------+---------+------+
| 1 | larry01 | 1 |
| 2 | larry02 | 2 |
+------+---------+------+
2 rows in set (0.00 sec)