一、MySQL完整备份操作
1、直接打包数据库文件夹
创建数据库auth:
MariaDB [(none)]> create database auth;
Query OK, 1 row affected (0.00 sec)
进入数据库:
MariaDB [(none)]>use auth
Database changed
创建数据表:
MariaDB [auth]> create table user(name char(10)not null,ID int(48));
Query OK, 0 rows affected (0.01 sec)
插入数据信息:
MariaDB [auth]>insert into user values('crushlinux','123');
Query OK, 1 row affected (0.01 sec)
查看数据信息:
MariaDB [auth]> select * from user;
+------------+------+
| name | ID |
+------------+------+
| crushlinux | 123 |
+------------+------+
1 row in set (0.00 sec)
对它进行备份
先退出MySQL停库
[root@localhost ~]# systemctl stop mariadb
直接对它进行打包压缩(新引入一个小命令)
[root@localhost ~]# rpm -q xz
xz-5.1.2-9alpha.el7.x86_64
[root@localhost ~]#mkdir backup // 创建一个文件,把压缩包放进去
[root@localhost ~]#tar Jcf backup/mysql_all-$(date +%F).tar.xz /var/lib/mysql/
tar: 从成员名中删除开头的“/”
模拟数据丢失:
[root@localhost ~]# rm -rf /var/lib/mysql/auth/
起服务:[root@localhost ~]# systemctl start mariadb
恢复数据:
[root@localhost ~]#mkdir restore //虽已创建一个文件
[root@localhost ~]# tar xf backup/mysql_all-2019-10-13.tar.xz -C restore/ 将那个压缩包解压到这个文件里
[root@localhost ~]# c