MySql Database 恢复(Percona XtraBackup)
amb02 install mysql 5.6# rpm -ivh percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm
# su - mysql
$ mkdir backup
# scp /etc/my.cnf root@192.168.1.202:/etc
# su - mysql
$ cd backup
$ scp -r 2018-02-04_03-00-01 mysql@192.168.1.202:/home/mysql/backup
$ scp -r 2018-02-05_03-00-01 mysql@192.168.1.202:/home/mysql/backup
# su - mysql
$ innobackupex --defaults-file=/etc/my.cnf --apply-log --redo-only /home/mysql/backup/2018-02-04_03-00-01/
$ innobackupex --defaults-file=/etc/my.cnf --apply-log /home/mysql/backup/2018-02-04_03-00-01/ --incremental-dir=/usr/local/mysql/backup/2018-02-05_03-00-01
$ innobackupex --defaults-file=/etc/my.cnf --copy-back /home/mysql/backup/2018-02-04_03-00-01/
# service mysqld start
Starting MySQL........
# service mysqld status
MySQL running (16025)
# cd /home/mysql/backup/2018-02-04_03-00-01
# cat xtrabackup_binlog_info
mysql-bin.000006 161257168
# mysql -uroot -pabcd.1234
mysql> flush logs;
Query OK, 0 rows affected (0.33 sec)
# su - mysql
$ cd /usr/local/mysql/data/
$ scp mysql-bin.000006 mysql@192.168.1.202:/home/mysql/backup/
# cd /home/mysql/backup/
# ll
total 157488
drwxr-x--- 6 mysql mysql 4096 Feb9 05:07 2018-02-04_03-00-01
drwxr-x--- 6 mysql mysql 4096 Feb9 05:07 2018-02-05_03-00-01
-rw-rw---- 1 mysql mysql 161257215 Feb9 05:25 mysql-bin.000006
# mysqlbinlog --start-position=161257168 /home/mysql/backup/mysql-bin.000006 | mysql -uroot -pabcd.1234
# mysql -uroot -pabcd.1234
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| tpcc1000 |
+--------------------+
4 rows in set (0.18 sec)
页:
[1]