mysql配置檔案添加:
innodb_file_per_table= 1 (這個至關重要!!!!*******每表單獨的表空間)
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/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.
xtrabackup: error: The transaction log file is corrupted.
xtrabackup: error: The log was not applied to the intended LSN!
xtrabackup: Log applied to lsn 3128344
xtrabackup: The intended lsn is 3129906
安裝步驟:
1.下載下傳位址
https://www.percona.com/downloads/XtraBackup/
2.準備安裝 :
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
此處會出錯:
A.問題
rpm -ivh perl-DBD-MySQL-4.013-3.el6.x86_64.rpm
warning: perl-DBD-MySQL-4.013-3.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by perl-DBD-MySQL-4.013-3.el6.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by perl-DBD-MySQL-4.013-3.el6.x86_64
解決辦法:
下載下傳:
MySQL-shared-compat-5.5.43-1.linux2.6.x86_64.rpm 安裝 rpm -ivh *****
B.問題
error: Failed dependencies:
libev.so.4 is needed by percona-xtrabackup-24-2.4.3-1.el6.i686
解決辦法:
https://pkgs.org/centos-6/repoforge-i386/libev-4.15-1.el6.rf.i686.rpm.html下載下傳檔案安裝
3.安裝XtrabackUp
rpm -ivh percona-xtrabackup-2.1.5-680.rhel6.x86_64.rpm
4.檢視版本
rpm -qa |grep xtrabackup 檢視版本
rpm -e percona-xtrabackup-2.2.10-1.el6.i686 解除安裝