Shulou(Shulou.com)06/01 Report--

1), download https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.7/binary/tarball/percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz tar xzvf percona-xtrabackup-2.4.7-Linux-x86_64.tar.gz 2), installation of Innobackupex-related dependency packages yum install perl-DBI yum install perl-DBD-MySQL yum install perl-Time-HiRes yum install perl-IO-Socket-SSL 3), Add the environment variable vi .bash _ profile PATH=$PATH:$HOME/bin:/apps/mysql5.7.16/bin:/apps/xtrabackup-2.4.7/bin PATH=$PATH:$HOME/bin:/apps/mysql5.7.16/bin:/apps/xtrabackup-2.4.7/bin

Fully prepared

/ xtrabackup/xtrabackup-2.4.7/bin/innobackupex-defaults-file=/etc/my.cnf-user=root-password= / data/myback/innodbbackup/

Restore

/ xtrabackup/xtrabackup-2.4.7/bin/innobackupex-defaults-file=/etc/my.cnf-user=root-password=-apply-log / data/myback/innodbbackup/

/ xtrabackup/xtrabackup-2.4.7/bin/innobackupex-defaults-file=/etc/my.cnf-user=root-password=-copy-back / data/myback/innodbbackup/

Or:

Restore binlogr

[root@robot-pbs-bigdata-02] # / xtrabackup/xtrabackup/bin/innobackupex-- defaults-file=/etc/my.cnf-- apply-log / data/xtrabackup/2017-09-07 / 15-04-49 /

Recovery library

[root@robot-pbs-bigdata-02] # / xtrabackup/xtrabackup/bin/innobackupex-- defaults-file=/etc/my.cnf-- copy-back / data/xtrabackup/2017-09-07 / 15-04-49 /

Change data permission

Activate.

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.