采坑 XtraBackup8.0

XtraBackup8.0 只支持mysql8.0之后的数据库备份。7.0+不支持

[root@zabbix_cn backup]# xtrabackup --default-files=/etc/my.cnf -uroot -proot --backup --backup-dir=/data/backup
xtrabackup: recognized server arguments: --server-id=114 --datadir=/data/mysql/data --tmpdir=/data/mysql/tmp --innodb_file_per_table=1 --innodb_buffer_pool_size=1G --innodb_data_home_dir=/data/mysql/data --innodb_data_file_path=ibdata1:1G:autoextend --innodb_read_io_threads=8 --innodb_write_io_threads=8 --innodb_io_capacity=3000 --innodb_flush_log_at_trx_commit=1 --innodb_log_buffer_size=32M --innodb_log_file_size=256M --innodb_log_files_in_group=2 --innodb_log_group_home_dir=/data/mysql/data --innodb_max_dirty_pages_pct=75 
xtrabackup: recognized client arguments: --port=3306 --socket=/tmp/mysql.sock --user=root --password=* --backup=1 
xtrabackup version 8.0.6 based on MySQL server 8.0.14 Linux (x86_64) (revision id: c0a2d91)
190514 20:59:34  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysql.sock' as 'root'  (using password: YES).
190514 20:59:34  version_check Connected to MySQL server
190514 20:59:34  version_check Executing a version check against the server...

# A software update is available:
190514 20:59:37 version_check Done.
190514 20:59:37 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock
Error: Unsupported server version: '5.7.22-log'.
This version of Percona XtraBackup can only perform backups and restores against MySQL 8.0 and Percona Server 8.0
Please use Percona XtraBackup 2.4 for this database.

安装percona的yum 资料库。选择合适的xtrabackup进行备份。注意了。
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

 

转载于:https://www.cnblogs.com/monkeybron/p/10868039.html