本文链接:mysql 8.0 xtrabackup简介与安装 -- cnDBA.cn_中国DBA社区
- 安装
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-8.0.4/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.4-1.el7.x86_64.rpm yum localinstall percona-xtrabackup-80-8.0.4-1.el7.x86_64.rpm
- 授权操作
CREATE USER 'backupuser'@'%' IDENTIFIED with mysql_native_password BY 'wwwwww'; GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'backupuser'@'%'; GRANT SELECT ON performance_schema.log_status TO 'backupuser'@'%'; FLUSH PRIVILEGES;
- 执行完全备份操作
[root@mysql ~]# xtrabackup --host=192.168.2.150 --port=3306 --user=backupuser --password=wwwwww --backup --target-dir=/data/mysql/ [root@mysql mysql]# cat xtrabackup_checkpoints backup_type = full-backuped from_lsn = 0 to_lsn = 431427667 last_lsn = 431427667 flushed_lsn = 0 [root@mysql mysql]# cat xtrabackup_binlog_info mysql-bin.000005 155
4.模拟删除数据库
mysql> drop database test;
Query OK, 2 rows affected (0.28 sec)
5.恢复全备
[root@mysql mysql]# /etc/init.d/mysqld stop
Shutting down MySQL..... SUCCESS!
[root@mysql mysql]# mv /mysql/data/ /mysql/data_bak
[root@mysql mysql]# mkdir /mysql/data
[root@mysql mysql]# chown mysql.mysql /mysql/data
[root@mysql mysql]# xtrabackup --host=192.168.2.150 --port=3306 --user=backupuser --password=wwwwww --datadir=/mysql/data --copy-back --target-dir=/data/mysql/