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

1. Full backuop, you must do it first:

Innobackupex-defaults-file=/etc/my.cnf-user=root-password=evlink / home/mysql/backup/

2. Incremental backup, you can do it every hour or three hours:

Innobackupex-defaults-file=/etc/my.cnf-user=root-password=evlink-incremental / home/mysql/backup/incre-incremental-basedir=/home/mysql/backup

Note: do an incremental backup for the second time-incremental must specify a new directory. -- incremental-basedir= unchanged

Restore. Note that the datadir specified by my.cnf must be empty, otherwise the restore fails:

Prepare restore:

Innobackupex-- defaults-file=/etc/my.cnf-- apply-log-- redo-only-- use-memory=4G / home/backup/2016-05-10 million 16-06-24 /

Innobackupex-defaults-file=/etc/my.cnf-apply-log-redo-only-use-memory=4G / home/backup/2016-05-10 million 16-06-24 /-- incremental-dir=/home/backup/incre/2016-05-10 million 16-15-55 /

Innobackupex-defaults-file=/etc/my.cnf-apply-log-use-memory=4G / home/backup/2016-05-10 16-06-24 /

Copy back:

Innobackupex-defaults-file=/etc/my.cnf-copy-back-use-memory=4G / home/backup/2016-05-10 16-06-24 /

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.