。）
| [root@localhost ~]# innobackupex --user=root /mybackups/ 省略...出现此行可以了。 140307 09:43:00 innobackupex: completed OK! [root@localhost ~]# |
1.12 查看备份后的数据：
| [root@localhost ~]# ls /mybackups/2014-03-07_09-42-56/ backup-my.cnf ibdata1 performance_schema xtrabackup_binary xtrabackup_checkpoints hellodb mysql test xtrabackup_binlog_info xtrabackup_logfile [root@localhost ~]# |
2.1 做一个完全备份还原恢复：
2.2 模拟停止服务及删除/data/mydata目录下的所有数据：（假设在备份前备份后没有做任何操作，怎么办呢）
| [root@localhost ~]# service mysqld stop Shutting down MySQL.. [ OK ] [root@localhost ~]# cd /data/mydata/ [root@localhost mydata]# ls aria_log.00000001 hellodb ib_logfile0 localhost.localdomain.err mysql test aria_log_control ibdata1 ib_logfile1 multi-master.info performance_schema [root@localhost mydata]# rm -rf ./* |
2.3 先准备(prepare)一个完全备份：
| [root@localhost mydata]# innobackupex --apply-log /mybackups/2014-03-07_09-42-56/ 看到如下几项就ok，一般在最后： xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1712150 140307 09:45:06 innobackupex: completed OK! [root@localhost mydata]# |
2.4 再从一个完全备份中恢复数据：
| [root@localhost mydata]# innobackupex --copy-back /mybackups/2014-03-07_09-42-56/ 看到如下几项就ok，一般在最后： 140307 09:49:06 innobackupex: completed OK! [root@localhost mydata]# |
2.5 修改其属组属主：
| [root@localhost mydata]# chown -R mysql:mysql ./* |
2.6 启动MySQL服务：
| [root@localhost mydata]# service mysqld start Starting MySQL.. [ OK ] [root@localhost mydata]# |
2.7 查看是否已成功恢复：
| MariaDB [(none)]> use hellodb Database changed MariaDB [hellodb]> SHOW TABLES; +-------------------+ | Tables_in_hellodb | +-------------------+ | classes | | coc | | courses | | scores | | students | | teachers | | toc | +-------------------+ |
（二）使用innobackupex进行增量备份
1、如何做基于时间点（增量）恢复的数据呢？？？？？
1.1 首先做一个完全备份：
| [root@localhost ~]# innobackupex --user=root /mybackups/ 省略...出现此行可以了。 140307 09:51:33 innobackupex: completed OK! |
1.2 查看备份的数据（注意：每一次备份都会产生新的备份数据目录的）：
| [root@localhost ~]# ls /mybackups/2014-03-07_09-51-29/ backup-my.cnf ibdata1 performance_schema xtrabackup_binary xtrabackup_checkpoints hellodb mysql test xtrabackup_binlog_info xtrabackup_logfile [root@localhost ~]# |
1.3 为了做第一次增量备份，插入数据:
| [root@localhost ~]# mysql MariaDB [(none)]> use hellodb MariaDB [hellodb]> CREATE TABLE tb1 (id int); MariaDB [hellodb]> INSERT INTO tb1 VALUES (1),(2); |
1.4 其次，在做第一次增量备份：
| [root@localhost ~]# innobackupex --incremental /mybackups/ --incremental-basedir=/mybackups/2014-03-07_09-51-29/ 省略...出现此行可以了。 140307 09:56:31 innobackupex: completed OK! [root@localhost ~]# |
1.5 xtrabackup_checkpoints —— 备份类型（如完全或增量）、备份状态（如是否已经为prepared状态）和LSN(日志序列号)范围信息；
| 1）查看完全与增量1的对比： [root@localhost ~]# cat /mybackups/2014-03-07_09-51-29/xtrabackup_checkpoints backup_type = full-backuped from_lsn = 0 to_lsn = 1712180 last_lsn = 1712180 compact = 0 [root@localhost ~]# ==对比== [root@localhost ~]# cat /mybackups/2014-03-07_09-56-26/xtrabackup_checkpoints backup_type = incremental from_lsn = 1712180 to_lsn = 1721035 last_lsn = 1721035 compact = 0 [root@localhost ~]# |
2.1 为了做第二次增量备份，再次插入数据:
| [root@localhost 2014-03-07_13-16-05]# mysql MariaDB [(none)]> CREATE DATABASE xiaoma; MariaDB [(none)]> use xiaoma MariaDB [xia |