安裝和測試xtrabackup8.0
Xtrabackup 2.4.已經(jīng)不支持MySQL 8.0的備份恢復(fù)，使用會報如下錯誤！
Error: MySQL 8.0 and Percona Server 8.0 are not supported by Percona Xtrabackup 2.4.x series. Please use Percona Xtrabackup 8.0.x for backups and restores.
mysql8.0
[root@enbao ~]# clear
[root@enbao ~]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
安裝percona-xtrabackup-80
[root@enbao soft]# yum -y install percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm
Installed:
percona-xtrabackup-80.x86_64 0:8.0.7-1.el7

站在用戶的角度思考問題，與客戶深入溝通，找到望城網(wǎng)站設(shè)計與望城網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗，讓設(shè)計與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個性化、用戶體驗好的作品，建站類型包括：網(wǎng)站制作、成都做網(wǎng)站、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣、空間域名、網(wǎng)頁空間、企業(yè)郵箱。業(yè)務(wù)覆蓋望城地區(qū)。

Complete!
查看安裝后結(jié)果，發(fā)現(xiàn)已經(jīng)沒有innobackupex命令
[root@enbao soft]# rpm -ql percona-xtrabackup-80-8.0.7-1.el7.x86_64
/usr/bin/xbcloud
/usr/bin/xbcloud_osenv
/usr/bin/xbcrypt
/usr/bin/xbstream
/usr/bin/xtrabackup
/usr/lib64/xtrabackup/plugin/keyring_file.so
/usr/lib64/xtrabackup/plugin/keyring_vault.so
/usr/share/doc/percona-xtrabackup-80-8.0.7
/usr/share/doc/percona-xtrabackup-80-8.0.7/LICENSE
/usr/share/man/man1/xbcrypt.1.gz
/usr/share/man/man1/xbstream.1.gz
/usr/share/man/man1/xtrabackup.1.gz
備份3306實例并恢復(fù)回3306
創(chuàng)建測試數(shù)據(jù)
root@enbao 09:56: [enbao]> create database test;
Query OK, 1 row affected (0.06 sec)

root@enbao 09:57: [enbao]> use test;
Database changed
root@enbao 09:57: [test]> create table t1(id int(10) NOT NULL AUTO_INCREMENT,name varchar(20),primary key(id));
Query OK, 0 rows affected, 1 warning (0.09 sec)
root@enbao 09:59: [test]> insert into t1(name) values('a'),('b'),('c');
Query OK, 3 rows affected (0.09 sec)
Records: 3 Duplicates: 0 Warnings: 0

root@enbao 10:00: [test]> select * from t1;
+----+------+
| id | name |
+----+------+
| 1 | a |
| 2 | b |
| 3 | c |
+----+------+
3 rows in set (0.00 sec)
創(chuàng)建備份目錄
[root@enbao data]# mkdir -p /data/backup/
1.xtrabackup --defaults-file=/data/mysql/my3306.cnf -S /data/mysql/mysql3306.sock -uroot -proot123 --backup --no-timestamp --target-dir=/data/backup/db3306_date +%Y%m%d

2. shutdown 原實例，冷備份原來數(shù)據(jù)
   [root@enbao soft]# mysqladmin -uroot -proot123 shutdown
   mv mysql3306 mysql3306_bak
3. mkdir mysql3306/{data,logs,tmp} -p
   進行數(shù)據(jù)恢復(fù)
4. xtrabackup --defaults-file=/data/mysql/my3306.cnf --copy-back --target-dir=/data/backup/db3306_20191027/
   更改目錄權(quán)限
5. chown -R mysql:mysql mysql3306
6. /usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my3306.cnf &
   查看error日志是否有錯誤，登錄到數(shù)據(jù)庫驗證可用性！
   [root@enbao logs]# grep -i "error" /data/mysql/mysql3306/logs/error.log
   2019-10-27T10:37:35.389830-04:00 1 [ERROR] [MY-011971] [InnoDB] Tablespace 'innodb_system' Page [page id: space=0, page number=5] log sequence number 29956511 is in the future! Current system log sequence number 29861388.
   2019-10-27T10:37:35.389873-04:00 1 [ERROR] [MY-011972] [InnoDB] Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html for information about forcing recovery.
   [root@enbao logs]# mysql -S /data/mysql/mysql3306.sock -p
   Enter password:
   Welcome to the MySQL monitor. Commands end with ; or \g.
   Your MySQL connection id is 9
   Server version: 8.0.17 MySQL Community Server - GPL
   root@enbao 11:01: [test]> select * from t1;
   +----+------+
   | id | name |
   +----+------+
   | 1 | a |
   | 2 | b |
   | 3 | c |
   +----+------+
   3 rows in set (0.00 sec)

root@enbao 11:01: [test]> insert into t1(name) values('d'),('e');
Query OK, 2 rows affected (0.04 sec)
Records: 2 Duplicates: 0 Warnings: 0

網(wǎng)頁標(biāo)題：安裝和測試xtrabackup8.0
鏈接URL：http://www.chinadenli.net/article48/jdhjhp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站導(dǎo)航、企業(yè)網(wǎng)站制作、企業(yè)建站、電子商務(wù)、建站公司、定制網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)