xtrabackup 8备份Mysql 8.0.18的过程是怎么样的

这篇文章给大家介绍xtrabackup 8备份Mysql 8.0.18的过程是怎么样的，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

1、首先 在mysql8里先建了一个稍微大一点的测试表，脚本：

CREATE TABLE user100w(  id INT NOT NULL AUTO_INCREMENT,  first_name VARCHAR(10) NOT NULL,  last_name VARCHAR(10) NOT NULL,  sex VARCHAR(5) NOT NULL,  score INT NOT NULL,  copy_id INT NOT NULL,  PRIMARY KEY (`id`));DROP PROCEDURE IF EXISTS add_user;  DELIMITER //    create PROCEDURE add_user(in num INT)    BEGIN        DECLARE rowid INT DEFAULT 0;        DECLARE firstname CHAR(1);        DECLARE name1 CHAR(1);        DECLARE name2 CHAR(1);        DECLARE lastname VARCHAR(3) DEFAULT '';        DECLARE sex CHAR(1);        DECLARE score CHAR(2);        WHILE rowid < num DO        SET firstname = SUBSTRING('赵钱孙李周吴郑王林杨柳刘孙陈江阮侯邹高彭徐',FLOOR(1+21*RAND()),1);         SET name1 = SUBSTRING('一二三四五六七八九十甲乙丙丁静景京晶名明铭敏闵民军君俊骏天田甜兲恬益依成城诚立莉力黎励',ROUND(1+43*RAND()),1);         SET name2 = SUBSTRING('一二三四五六七八九十甲乙丙丁静景京晶名明铭敏闵民军君俊骏天田甜兲恬益依成城诚立莉力黎励',ROUND(1+43*RAND()),1);         SET sex=FLOOR(0 + (RAND() * 2));        SET score= FLOOR(40 + (RAND() *60));        SET rowid = rowid + 1;        IF ROUND(RAND())=0 THEN         SET lastname =name1;        END IF;        IF ROUND(RAND())=1 THEN        SET lastname = CONCAT(name1,name2);        END IF;        insert INTO user100w (first_name,last_name,sex,score,copy_id) VALUES (firstname,lastname,sex,score,rowid);          END WHILE;    END //DELIMITER ;call add_user(10000);

2、yum安装依赖

[root@centos1 ~]# yum install libev

3、下载xtrabackup后，直接用yum安装

[root@centos1 opt]# wget https://www.percona.com/downloads/Percona-XtraBackup-LATEST/Percona-XtraBackup-8.0-7/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm

Saving to: 'percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm'100%[+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++=======================>] 12,177,712  22.2KB/s   in 2m 20s 2019-11-08 17:39:37 (21.5 KB/s) - 'percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm' saved [12177712/12177712][root@centos1 opt]# yum localinstall percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpmInstalled:  percona-xtrabackup-80.x86_64 0:8.0.7-1.el7                                                                                       Dependency Installed:  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7   perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7   perl-DBD-MySQL.x86_64 0:4.023-6.el7    perl-DBI.x86_64 0:1.627-4.el7                  perl-Digest.noarch 0:1.17-245.el7             perl-Digest-MD5.x86_64 0:2.52-3.el7    perl-IO-Compress.noarch 0:2.061-2.el7          perl-Net-Daemon.noarch 0:0.48-5.el7           perl-PlRPC.noarch 0:0.2020-14.el7   Complete![root@centos1 opt]# xtrabackup -vxtrabackup: recognized server arguments: --datadir=/var/lib/mysql xtrabackup version 8.0.7 based on MySQL server 8.0.16 Linux (x86_64) (revision id: 069e0e6)

问题来了 我的mysql是8.0.18的（装好之后发现并没有什么问题）

4、开始备份

一些参数：

According to your system, you may need to specify one or more of the following options to connect to the server:

备份（如果不是localhost的远程备份的话，mysql需要更新User表可以远程登录）：

[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf --host=localhost --user=root --password=mysqlWAI --port=3306 --socket=/data/mysql/run/mysql.sock --backup --target-dir=/home/mysql/xbackup/

备份时插入一条数据做测试

mysql> select * from test1 ;+------+------+| id   | code |+------+------+|    1 | 3009 ||    2 | 3010 ||    3 | 3011 |+------+------+3 rows in set (0.00 sec)mysql> insert into test1 values(4,3099);

备份完成会提示：

191111 18:09:24 All tables unlocked191111 18:09:24 Backup created in directory '/home/mysql/xbackup/'MySQL binlog position: filename 'mysql-bin.000004', position '155'191111 18:09:24 [00] Writing /home/mysql/xbackup/backup-my.cnf191111 18:09:24 [00]        ...done191111 18:09:24 [00] Writing /home/mysql/xbackup/xtrabackup_info191111 18:09:24 [00]        ...donextrabackup: Transaction log of lsn (23556373) to (23556739) was copied.191111 18:09:24 completed OK!

查看一下备份的情况

[mysql@centos1 xbackup]$ lltotal 2142252-rw-r----- 1 mysql mysql        499 Nov 11 18:09 backup-my.cnf-rw-r----- 1 mysql mysql 2147483648 Nov 11 18:09 ibdata1drwxr-x--- 2 mysql mysql        157 Nov 11 18:09 mysql-rw-r----- 1 mysql mysql        155 Nov 11 18:09 mysql-bin.000004-rw-r----- 1 mysql mysql         36 Nov 11 18:09 mysql-bin.index-rw-r----- 1 mysql mysql   25165824 Nov 11 18:09 mysql.ibddrwxr-x--- 2 mysql mysql       8192 Nov 11 18:09 performance_schemadrwxr-x--- 2 mysql mysql         43 Nov 11 18:09 srlgdrwxr-x--- 2 mysql mysql         28 Nov 11 18:09 sys-rw-r----- 1 mysql mysql   10485760 Nov 11 18:09 undo_001-rw-r----- 1 mysql mysql   10485760 Nov 11 18:09 undo_002-rw-r----- 1 mysql mysql         21 Nov 11 18:09 xtrabackup_binlog_info-rw-r----- 1 mysql mysql         95 Nov 11 18:09 xtrabackup_checkpoints-rw-r----- 1 mysql mysql        581 Nov 11 18:09 xtrabackup_info-rw-r----- 1 mysql mysql       3072 Nov 11 18:09 xtrabackup_logfile-rw-r----- 1 mysql mysql        264 Nov 11 18:09 xtrabackup_tablespaces

[mysql@centos1 xbackup]$ cat xtrabackup_checkpoints backup_type = full-backupedfrom_lsn = 0to_lsn = 23556719last_lsn = 23556729flushed_lsn = 0

[mysql@centos1 xbackup]$ cat xtrabackup_info uuid = 562944f7-046b-11ea-984b-10e7c62c3e49name = tool_name = xtrabackuptool_command = --defaults-file=/data/mysql/my.cnf --host=localhost --user=root --password=... --port=3306 --socket=/data/mysql/run/mysql.sock --backup --target-dir=/home/mysql/xbackup/tool_version = 8.0.7ibbackup_version = 8.0.7server_version = 8.0.18start_time = 2019-11-11 18:08:43end_time = 2019-11-11 18:09:24lock_time = 0binlog_pos = filename 'mysql-bin.000004', position '155'innodb_from_lsn = 0innodb_to_lsn = 23556719partial = Nincremental = Nformat = filecompressed = Nencrypted = N

此时删掉mysql一个表作测试

mysql> show tables    -> ;+----------------+| Tables_in_srlg |+----------------+| test1          || user100w       |+----------------+2 rows in set (0.00 sec)mysql> drop table user100w;Query OK, 0 rows affected (0.10 sec)

创建备份用户根据官方：

An SQL example of creating a database user with the minimum privileges required to full backups would be:

mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cr%T';mysql> GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';mysql> GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';mysql> FLUSH PRIVILEGES;

准备恢复

[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf --user=root --prepare --target-dir=/home/mysql/xbackup/Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.Page cleaner took 23005ms to flush 0 and evict 0 pages8.0.16 started; log sequence number 23557132xtrabackup: starting shutdown with innodb_fast_shutdown = 1FTS optimize thread exiting.Starting shutdown...Log background threads are being closed...Shutdown completed; log sequence number 23557132191111 18:32:11 completed OK![mysql@centos1 ~]$[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf--user=root --copy-back --target-dir=/home/mysql/xbackup/

报错

[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf--user=root --copy-back --target-dir=/home/mysql/xbackup/xtrabackup: [ERROR] Failed to open required defaults file: /data/mysql/my.cnf--user=rootxtrabackup: [ERROR] Fatal error in defaults handling. Program aborted!

修改权限

[root@centos1 mysql]# chmod 755 /data/mysql/my.cnf

[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf --user=mysql --copy-back --target-dir=/home/mysql/xbackup/xtrabackup: recognized server arguments: --datadir=/data/mysql/data --tmpdir=/data/mysql/tmp --open_files_limit=65535 --server-id=1 --log_bin=/data/mysql/binlog/mysql-bin --innodb_buffer_pool_size=4096M --innodb_file_per_table=1 --innodb_data_home_dir=/data/mysql/innodb_ts --innodb_data_file_path=ibdata1:2048M:autoextend --innodb_log_buffer_size=67108864 --innodb_log_file_size=1048576000 --innodb_log_files_in_group=4 --innodb_undo_directory=/data/mysql/undo_space --innodb_log_group_home_dir=/data/mysql/innodb_log --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=60 --innodb_open_files=60000 --innodb_read_io_threads=4 --innodb_flush_method=O_DIRECT xtrabackup: recognized client arguments: --port=3306 --socket=/data/mysql/run/mysql.sock --user=mysql --copy-back=1 --target-dir=/home/mysql/xbackup/ xtrabackup version 8.0.7 based on MySQL server 8.0.16 Linux (x86_64) (revision id: 069e0e6)Original data directory /data/mysql/data is not empty!

oh 对了恢复的话 相关文件目录/data/mysql/data要删掉。。。 重来吧

看看备份目录内容 多了一些日志：

[mysql@centos1 data]$ cd /home/mysql/xbackup[mysql@centos1 xbackup]$ lltotal 6258732-rw-r----- 1 mysql mysql        499 Nov 11 18:09 backup-my.cnf-rw-r----- 1 mysql mysql 2147483648 Nov 11 18:32 ibdata1-rw-r----- 1 mysql mysql 1048576000 Nov 11 18:32 ib_logfile0-rw-r----- 1 mysql mysql 1048576000 Nov 11 18:31 ib_logfile1-rw-r----- 1 mysql mysql 1048576000 Nov 11 18:31 ib_logfile2-rw-r----- 1 mysql mysql 1048576000 Nov 11 18:32 ib_logfile3-rw-r----- 1 mysql mysql   12582912 Nov 11 18:32 ibtmp1drwxrwx--- 2 mysql mysql          6 Nov 11 18:32 #innodb_tempdrwxr-x--- 2 mysql mysql        157 Nov 11 18:09 mysql-rw-r----- 1 mysql mysql        155 Nov 11 18:09 mysql-bin.000004-rw-r----- 1 mysql mysql         36 Nov 11 18:09 mysql-bin.index-rw-r----- 1 mysql mysql   25165824 Nov 11 18:09 mysql.ibddrwxr-x--- 2 mysql mysql       8192 Nov 11 18:09 performance_schemadrwxr-x--- 2 mysql mysql         43 Nov 11 18:09 srlgdrwxr-x--- 2 mysql mysql         28 Nov 11 18:09 sys-rw-r----- 1 mysql mysql   10485760 Nov 11 18:09 undo_001-rw-r----- 1 mysql mysql   10485760 Nov 11 18:09 undo_002-rw-r----- 1 mysql mysql         21 Nov 11 18:09 xtrabackup_binlog_info-rw-r----- 1 mysql mysql         95 Nov 11 18:31 xtrabackup_checkpoints-rw-r----- 1 mysql mysql        581 Nov 11 18:09 xtrabackup_info-rw-r----- 1 mysql mysql    8388608 Nov 11 18:31 xtrabackup_logfile-rw-rw-r-- 1 mysql mysql          1 Nov 11 18:31 xtrabackup_master_key_id-rw-r----- 1 mysql mysql        264 Nov 11 18:32 xtrabackup_tablespaces

[mysql@centos1 xbackup]$ cd /data/mysql[mysql@centos1 mysql]$ lltotal 36drwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 backupdrwxrwxr-x 2 mysql mysql   125 Nov 11 18:09 binlogdrwxr-xr-x 7 mysql mysql   288 Nov  8 11:25 datadrwxrwxr-x 2 mysql mysql    82 Oct 31 11:29 innodb_logdrwxrwxr-x 2 mysql mysql    57 Nov  8 11:25 innodb_tsdrwxr-xr-x 2 mysql mysql     6 Oct 25 16:29 log-rwxr-xr-x 1 mysql mysql  2690 Oct 31 12:02 my.cnf-rw-r----- 1 mysql mysql     6 Nov  8 11:25 mysqld.pid-rw-r----- 1 mysql mysql 24410 Nov 11 18:08 mysql-error.logdrwxr-xr-x 2 mysql mysql    90 Nov  8 11:25 rundrwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 scripts-rw-r----- 1 mysql mysql   744 Nov  8 13:23 slow_statement.logdrwxr-xr-x 3 mysql mysql    53 Oct 29 17:26 tmpdrwxr-x--- 2 mysql mysql    38 Oct 31 11:29 undo_space[mysql@centos1 mysql]$ mv data data_bk[mysql@centos1 mysql]$ mv binlog binlog_bk[mysql@centos1 mysql]$ mv innodb_log innodb_log_bk[mysql@centos1 mysql]$ cd innodb_ts/[mysql@centos1 innodb_ts]$ lltotal 2109448-rw-r----- 1 mysql mysql       4509 Oct 31 17:34 ib_buffer_pool-rw-r----- 1 mysql mysql 2147483648 Nov 11 18:34 ibdata1-rw-r----- 1 mysql mysql   12582912 Nov  8 11:26 ibtmp1[mysql@centos1 innodb_ts]$ cd ..[mysql@centos1 mysql]$ mv innodb_ts innodb_ts_bk[mysql@centos1 mysql]$ cd log[mysql@centos1 log]$ lltotal 0[mysql@centos1 log]$ cd ..[mysql@centos1 mysql]$ cd tmp[mysql@centos1 tmp]$ lltotal 113284drwxr-xr-x 8 root root       319 Apr 10  2019 boost_1_70_0-rw-r--r-- 1 root root 116000903 Oct 29 17:26 boost_1_70_0.tar.gz[mysql@centos1 tmp]$ cd ..[mysql@centos1 mysql]$ cd undo_space/[mysql@centos1 undo_space]$ lltotal 20480-rw-r----- 1 mysql mysql 10485760 Nov 11 18:34 undo_001-rw-r----- 1 mysql mysql 10485760 Nov 11 18:33 undo_002[mysql@centos1 undo_space]$ cd ..[mysql@centos1 mysql]$ mv undo_space undo_space_bk[mysql@centos1 mysql]$ lltotal 36drwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 backupdrwxrwxr-x 2 mysql mysql   125 Nov 11 18:09 binlog_bkdrwxr-xr-x 7 mysql mysql   288 Nov  8 11:25 data_bkdrwxrwxr-x 2 mysql mysql    82 Oct 31 11:29 innodb_log_bkdrwxrwxr-x 2 mysql mysql    57 Nov  8 11:25 innodb_ts_bkdrwxr-xr-x 2 mysql mysql     6 Oct 25 16:29 log-rwxr-xr-x 1 mysql mysql  2690 Oct 31 12:02 my.cnf-rw-r----- 1 mysql mysql     6 Nov  8 11:25 mysqld.pid-rw-r----- 1 mysql mysql 24410 Nov 11 18:08 mysql-error.logdrwxr-xr-x 2 mysql mysql    90 Nov  8 11:25 rundrwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 scripts-rw-r----- 1 mysql mysql   744 Nov  8 13:23 slow_statement.logdrwxr-xr-x 3 mysql mysql    53 Oct 29 17:26 tmpdrwxr-x--- 2 mysql mysql    38 Oct 31 11:29 undo_space_bk

这样很多很麻烦啊。。对了我直接删掉整个目录就好了吧。。。

[mysql@centos1 mysql]$ cd ..[mysql@centos1 data]$ lltotal 0drwxr-xr-x 12 mysql mysql 243 Nov 12 11:00 mysql[mysql@centos1 data]$ mv mysql mysql_bkmv: cannot move 'mysql' to 'mysql_bk': Permission denied[mysql@centos1 data]$ lltotal 0drwxr-xr-x 12 mysql mysql 243 Nov 12 11:00 mysql[mysql@centos1 data]$ su - rootPassword: su: Authentication failure[mysql@centos1 data]$ su - rootPassword: Last login: Tue Nov 12 10:40:42 CST 2019 from desktop-v9u5026 on pts/1Last failed login: Tue Nov 12 11:04:08 CST 2019 on pts/1There was 1 failed login attempt since the last successful login.[root@centos1 ~]# chmod 755 /data/mysql[root@centos1 ~]# cd /data[root@centos1 data]# lltotal 0drwxr-xr-x 12 mysql mysql 243 Nov 12 11:00 mysql

[root@centos1 data]# chmod 777 /data/mysql[root@centos1 data]# lltotal 0drwxrwxrwx 12 mysql mysql 243 Nov 12 11:00 mysql[root@centos1 data]# su - mysqlLast login: Tue Nov 12 10:45:32 CST 2019 on pts/1[mysql@centos1 ~]$ cd /data[mysql@centos1 data]$ lltotal 0drwxrwxrwx 12 mysql mysql 243 Nov 12 11:00 mysql[mysql@centos1 data]$ mv mysql mysql_bkmv: cannot move 'mysql' to 'mysql_bk': Permission denied[mysql@centos1 data]$ lltotal 0drwxrwxrwx 12 mysql mysql 243 Nov 12 11:00 mysql[mysql@centos1 data]$ cd[mysql@centos1 ~]$ pwd/home/mysql

好吧 不行mv不了 还是按刚刚那样吧
重新做恢复的过程，先看看进程吧

[mysql@centos1 mysql]$ ps -ef|grep mysqlroot      8867  8496  0 10:45 pts/1    00:00:00 su - mysqlmysql     8868  8867  0 10:45 pts/1    00:00:00 -bashmysql     9850     1  0 Nov08 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql/my.cnf --user=mysqlroot     10468 10216  0 11:07 pts/1    00:00:00 su - mysqlmysql    10469 10468  0 11:07 pts/1    00:00:00 -bashmysql    10738  9850  0 Nov08 ?        00:48:01 /usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my.cnf --basedir=/usr/localmysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/data/mysql/mysqld.pid --socket=/data/mysql/run/mysql.sock --port=3306mysql    11009 10469  0 11:14 pts/1    00:00:00 ps -efmysql    11010 10469  0 11:14 pts/1    00:00:00 grep --color=auto mysql

什么鬼？我记得我停掉mysql了啊 竟然忘了？ 那当然不能mv mysql了啊 晕。。。

停掉mysql

[mysql@centos1 bin]$ /usr/local/mysql/bin/mysqladmin -h 127.0.0.1 -uroot -pmysqlWAI -P3306 -S /data/mysql/run/mysql.sock shutdownmysqladmin: [Warning] Using a password on the command line interface can be insecure.[mysql@centos1 bin]$ ps -ef|grep mysqlroot      8867  8496  0 10:45 pts/1    00:00:00 su - mysqlmysql     8868  8867  0 10:45 pts/1    00:00:00 -bashroot     10468 10216  0 11:07 pts/1    00:00:00 su - mysqlmysql    10469 10468  0 11:07 pts/1    00:00:00 -bashmysql    11341 10469  0 11:19 pts/1    00:00:00 ps -efmysql    11342 10469  0 11:19 pts/1    00:00:00 grep --color=auto mysql

重新创建空目录

[mysql@centos1 mysql]$ mkdir data[mysql@centos1 mysql]$ mkdir binlog[mysql@centos1 mysql]$ mkdir innodb_log[mysql@centos1 mysql]$ mkdir innodb_ts[mysql@centos1 mysql]$ mkdir undo_space[mysql@centos1 mysql]$ mv tmp tmp_bk[mysql@centos1 mysql]$ mkdir tmp

准备恢复 --prepare （这个好像是将备份集备份后MySQL运行产生的日志合并之类的）

[mysql@centos1 mysql]$ xtrabackup --defaults-file=/data/mysql/my.cnf --user=root --prepare --target-dir=/home/mysql/xbackup/Creating shared tablespace for temporary tablesSetting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...File './ibtmp1' size is now 12 MB.Scanning temp tablespace dir:'./#innodb_temp/'Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.8.0.16 started; log sequence number 23557132xtrabackup: starting shutdown with innodb_fast_shutdown = 1FTS optimize thread exiting.Starting shutdown...Log background threads are being closed...Shutdown completed; log sequence number 23557132191112 11:30:58 completed OK!

跟上次的序列号是一样的 大概是因为没有产生过数据变更

--copy-back：

[mysql@centos1 ~]$ xtrabackup --defaults-file=/data/mysql/my.cnf --user=mysql --copy-back --target-dir=/home/mysql/xbackup/191112 11:38:32 [01] Copying ./xtrabackup_info to /data/mysql/data/xtrabackup_info191112 11:38:32 [01]        ...done191112 11:38:32 [01] Copying ./xtrabackup_master_key_id to /data/mysql/data/xtrabackup_master_key_id191112 11:38:32 [01]        ...done191112 11:38:32 [01] Copying ./ibtmp1 to /data/mysql/data/ibtmp1191112 11:38:32 [01]        ...done191112 11:38:32 [01] Creating directory ./#innodb_temp191112 11:38:32 [01] ...done.191112 11:38:32 completed OK!

查看恢复后的文件，新建的文件夹有数据了：

[mysql@centos1 ~]$ cd /data/mysql[mysql@centos1 mysql]$ lltotal 36drwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 backupdrwxrwxr-x 2 mysql mysql    53 Nov 12 11:38 binlogdrwxrwxr-x 2 mysql mysql   125 Nov 11 18:09 binlog_bkdrwxrwxr-x 6 mysql mysql   154 Nov 12 11:38 datadrwxr-xr-x 7 mysql mysql   288 Nov  8 11:25 data_bkdrwxrwxr-x 2 mysql mysql    82 Nov 12 11:37 innodb_logdrwxrwxr-x 2 mysql mysql    82 Oct 31 11:29 innodb_log_bkdrwxrwxr-x 2 mysql mysql    21 Nov 12 11:37 innodb_tsdrwxrwxr-x 2 mysql mysql    57 Nov  8 11:25 innodb_ts_bkdrwxr-xr-x 2 mysql mysql     6 Oct 25 16:29 log-rwxr-xr-x 1 mysql mysql  2690 Oct 31 12:02 my.cnf-rw-r----- 1 mysql mysql 25145 Nov 12 11:18 mysql-error.logdrwxr-xr-x 2 mysql mysql     6 Nov 12 11:18 rundrwxrwxr-x 2 mysql mysql     6 Oct 30 15:31 scripts-rw-r----- 1 mysql mysql   744 Nov  8 13:23 slow_statement.logdrwxrwxr-x 2 mysql mysql     6 Nov 12 11:25 tmpdrwxr-xr-x 3 mysql mysql    53 Oct 29 17:26 tmp_bkdrwxrwxr-x 2 mysql mysql    38 Nov 12 11:37 undo_spacedrwxr-x--- 2 mysql mysql    38 Oct 31 11:29 undo_space_bk[mysql@centos1 mysql]$ cd data[mysql@centos1 data]$ lltotal 36884-rw-r----- 1 mysql mysql 12582912 Nov 12 11:38 ibtmp1drwxr-x--- 2 mysql mysql      157 Nov 12 11:38 mysql-rw-r----- 1 mysql mysql 25165824 Nov 12 11:38 mysql.ibddrwxr-x--- 2 mysql mysql     8192 Nov 12 11:38 performance_schemadrwxr-x--- 2 mysql mysql       43 Nov 12 11:38 srlgdrwxr-x--- 2 mysql mysql       28 Nov 12 11:38 sys-rw-r----- 1 mysql mysql      581 Nov 12 11:38 xtrabackup_info-rw-r----- 1 mysql mysql        1 Nov 12 11:38 xtrabackup_master_key_id[mysql@centos1 data]$ cd ..[mysql@centos1 mysql]$ cd binlog[mysql@centos1 binlog]$ lltotal 8-rw-r----- 1 mysql mysql 155 Nov 12 11:38 mysql-bin.000004-rw-r----- 1 mysql mysql  36 Nov 12 11:38 mysql-bin.index

启动mysql：

[mysql@centos1 ~]$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql/my.cnf --user=mysql &[1] 13666[mysql@centos1 ~]$ 2019-11-12T03:51:22.072187Z mysqld_safe Logging to '/data/mysql/mysql-error.log'.2019-11-12T03:51:22.147329Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data

[mysql@centos1 ~]$ ps -ef |grep mysqlroot      8867  8496  0 10:45 pts/1    00:00:00 su - mysqlmysql     8868  8867  0 10:45 pts/1    00:00:00 -bashroot     10468 10216  0 11:07 pts/1    00:00:00 su - mysqlmysql    10469 10468  0 11:07 pts/1    00:00:00 -bashroot     12670 12624  0 11:37 pts/0    00:00:00 su - mysqlmysql    12671 12670  0 11:37 pts/0    00:00:00 -bashmysql    13666 12671  0 11:51 pts/0    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql/my.cnf --user=mysqlmysql    14555 13666  5 11:51 pts/0    00:00:01 /usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my.cnf --basedir=/usr/localmysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/data/mysql/mysqld.pid --socket=/data/mysql/run/mysql.sock --port=3306root     14666 14621  0 11:51 pts/2    00:00:00 su - mysqlmysql    14667 14666  0 11:51 pts/2    00:00:00 -bashmysql    14713 14667  0 11:51 pts/2    00:00:00 ps -efmysql    14714 14667  0 11:51 pts/2    00:00:00 grep --color=auto mysql

登录

[mysql@centos1 ~]$ mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.0.18 nancy editionCopyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use srlgDatabase changedmysql> show tables;+----------------+| Tables_in_srlg |+----------------+| test1          || user100w       |+----------------+2 rows in set (0.02 sec)mysql> select * from test1;+------+------+| id   | code |+------+------+|    1 | 3009 ||    2 | 3010 ||    3 | 3011 ||    4 | 3099 |+------+------+4 rows in set (0.02 sec)mysql> select count(*) from user100w;+----------+| count(*) |+----------+|    10000 |+----------+1 row in set (0.02 sec)

查看备份时候插入的数据，以及备份之后删除的表都存在。

关于xtrabackup 8备份Mysql 8.0.18的过程是怎么样的就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。