mysql innobackupex 物理备份

可以通过以下文件查看备份信息。

[root@drbd-01 backup]# cat /data/backup/full/2015-07-28_12-10-45/xtrabackup_checkpoints

backup_type = full-backuped

from_lsn = 0

to_lsn = 3194902

last_lsn = 3194902

compact = 0

[root@drbd-01 backup]# cat /data/backup/001/xtrabackup_checkpoints

backup_type = incremental

from_lsn = 3194902

to_lsn = 3198776

last_lsn = 3198776

compact = 0

[root@drbd-01 backup]# cat /data/backup/002/xtrabackup_checkpoints

backup_type = incremental

f开发云主机域名rom_lsn = 3198776

to_lsn = 3202726

last_lsn = 3202726

compact = 0

删除原来的mysql数据目录/data/mysql，创建新的数据库目录，用来模拟数据库损坏。

[root@drbd-01 data]#rm –rf /data/mysql

[root@drbd-01 data]# cd /data/

[root@drbd-01 data]# mkdir mysql

[root@drbd-01 data]# chown mysql.mysql mysql

[root@drbd-01 ~]# innobackupex –defaults-file=/etc/my.cnf –copy-back /data/backup/full/2015-07-28_12-10-45/

chown -R mysql:mysql /data/mysql

相关推荐: MySQL生产环境最优的配置实战

操作系统环境配置（生产环境最优的配置）4.1 hostsecho “192.168.1.51 db1” >>/etc/hostscat /etc/hostsnproc，操作系统对用户创建进程数的资源限制nofile，每个进程能打开文件的次数（文件描…