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

I am a tool for backing up MySQL data. I was born in Percona's home.

download

My home address: http://www.percona.com/

Enter: Software-- > Percona XtraBackup-- > Download Percona XtraBackup Now

Version: Percona-XtraBackup-2.4.11/Centos 7/x86_64

Download command

Shell > wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.11/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.11-1.el7.x86_64.rpm

Installation

My installation is very easy, enter the following command to complete the installation, and solve the problem of software dependency.

Shell > yum localinstall percona-xtrabackup-24-2.4.11-1.el7.x86_64.rpm

Backup

Let me get to work, backup work.

Shell > innnobackupex-- defaults-file=/data/mysql/mysql3306/my3306.cnf-S / tmp/mysql3306.sock-uroot-plmlm / data/backup/

Restore

The data is lost, the server is broken, don't worry, I have it, the recovery work goes like this.

Use redo logshell > innobackupex-- apply-log / data/backup/filename/ to close MySQLshell > mysqladmin-S / tmp/mysql3306.sock-p shutdown to remove old data shell > mv / path/data/* / tmp/oldboy_data_time copy file shell > innobackupex-- defaults-file=/data/mysql/mysql3306/my3306.cnf-- copy-back / data/backup/filename/ modify permissions shell > chown-R mysql:mysql / path/data/ start and check

Let's start the database and check the error log, and it all looks fine.

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.