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

Today, the editor shares with you the method of using xtrabackup to back up mysql database, which is not well understood by many people. Today, in order to give you a better understanding of how xtrabackup backs up mysql database, I have summarized the following contents for you. Let's look down together. I'm sure you'll get something.

Using xtrabackup to back up mysql Database

one。 Installation

1. Download binaries directly

Wget http://www.percona.com/downloads/XtraBackup/XtraBackup-2.1.9/binary/Linux/x86_64/percona-xtrabackup-2.1.9-744-Linux-x86_64.tar.gz

Put it in the corresponding directory after decompression.

two。 Add the bin directory of the file to the environment variable, or copy the execution file to the / usr/bin directory, otherwise you will report

Sh: xtrabackup_55: command not found

Innobackupex: fatal error: no 'mysqld' group in MySQL options

Error

Second, basic use

1. Full backup

Innobackupex-user=root-password=123456 / mysql_backup

two。 Back up the specified database db_c

Innobackupex-user=root-password=123456-include= "db_c" / mysql_backup

three。 Restore

Because the backup of xtrabackup is a physical backup and the corresponding files are copied, the recovery is also to overwrite the files to the datadir directory of mysql and give the corresponding permissions.

The above is a brief introduction to the method of using xtrabackup to back up mysql database. Of course, the differences in the detailed use of the above have to be understood by everyone. If you want to know more, welcome to follow the industry information channel!

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.