Shulou(Shulou.com)05/31 Report--

This article introduces what the process of xtrabackup 8 backup Mysql 8.0.18 is like, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. First, a slightly larger test table is created in mysql8, and the script:

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.rpmSaving to: 'percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm'100%[+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++=======================>

] 12177712 22.2KB/s in 2m 20s 2019-11-08 17:39:37 (21.5KB/s)-'percona-xtrabackup-80-8.0.7-1.el7.x86room64.rpm' saved [12177712 22.2KB/s in 12177712] [root@centos1 opt] # yum localinstall percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpmInstalled: percona-xtrabackup-80.x86_64 0pur8.0.7-1.el7 Dependency Installed: perl-Compress-Raw-Bzip2.x86_64 0v 2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1v 2.061-4.el7 perl-DBD-MySQL.x86_64 0V 4.023-6.el7 perl-DBI.x86_64 0v 1.627-4.el7 Perl-Digest.noarch 0VOR 1.17-245.el7 perl-Digest-MD5.x86_64 0VOR 2.52-3.el7 perl-IO-Compress.noarch 0RU 2.061-2.el7 perl-Net-Daemon.noarch 0RU 0.48-5.el7 perl-PlRPC.noarch 0Ro 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)

The problem is that my mysql is 8.0.18 (after installing it, I found that there is no problem)

4. Start backup

Some parameters:

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

OptionDescription-portThe port to use when connecting to the database server with TCP/IP.-socketThe socket to use when connecting to the local database.-hostThe host to use when connecting to the database server with TCP/IP.

Backup (if it is not a remote backup of localhost, mysql needs to update the User table to log in remotely):

[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/

Insert a piece of data to test during backup

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

When the backup is complete, it prompts:

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!

Check the backup.

[mysql@centos1 xbackup] $lltotal 2142252 mysql mysql 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 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

Delete a table of mysql for testing at this time.

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)

Create backup users according to the official:

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' s 3cr% Thumbach 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

Prepare for recovery

[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. 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/

Error

[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!

Modify permissions

[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!

If oh is right, the related file directory / data/mysql/data should be deleted. Let's start over.

Take a look at the backup directory with more logs:

[mysql@centos1 data] $cd / home/mysql/xbackup [mysql@centos1 xbackup] $lltotal 6258732 mysql@centos1 data 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 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 RWMI 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 mysql 10485760 Nov 11 18:34 undo_001-rw-r- 1 mysql mysql 10485760 Nov 11 18:33 undo_002 [mysql@centos1 undo_space] $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 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

This is a lot of trouble. By the way, I'll just delete the whole catalog.

[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 2443 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 Nov 12 11:00 mysql [mysql@centos1 data] $cd [mysql@centos1 ~] $pwd/home/mysql

Okay, no, mv, no, let's just do it that way.

Redo the recovery process and take a look at the process first.

[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 10 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

What the hell? I remember I stopped mysql. How could you forget? Of course you can't mv mysql. Dizzy.

Stop the 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

Recreate the empty directory

[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 for recovery-prepare (this is like merging the logs generated by MySQL running after the backup set is backed up)

[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!

The serial number is the same as the last time, probably because there has been no data change.

-- 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!

Check the restored file, and the newly created folder has data:

[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 -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 RWMurray 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

Start 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 126700 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

Log in

[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.02sec) mysql > select count (*) from user100w +-+ | count (*) | +-+ | 10000 | +-+ 1 row in set (0.02 sec)

Both the data inserted during the backup and the tables deleted after the backup exist.

About xtrabackup 8 backup Mysql 8.0.18 how the process is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.