设为首页 加入收藏

TOP

xtrabackup热备和恢复MySQL(四)
2018-08-24 09:22:09 】 浏览:368
Tags:xtrabackup 恢复 MySQL
RTANT: Please check that the backup runcompletes successfully.


          Atthe end of a successful backup run innobackupex


          prints "completed OK!".


innobackupex: Using mysql server version 5.5.48


innobackupex: Created backup directory /backup/full_data/2017-04-04_13-28-58


170404 13:28:58 innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --backup--suspend-at-end --target-dir=/backup/full_data/2017-04-04_13-28-58 --tmpdir=/tmp


innobackupex: Waiting for ibbackup (pid=26398) tosuspend


innobackupex: Suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_suspended_2'


xtrabackup_55 version 2.1.9 for Percona Server5.5.35 Linux (x86_64) (revision id: 744)


xtrabackup: uses posix_fadvise().


xtrabackup: cd to /data/mysql/


xtrabackup: open files limit requested 65535, setto 65535


xtrabackup: using the following InnoDBconfiguration:


xtrabackup:  innodb_data_home_dir = /usr/local/mysql/var


xtrabackup:  innodb_data_file_path = ibdata1:10M:autoextend


xtrabackup:  innodb_log_group_home_dir = /usr/local/mysql/var


xtrabackup:  innodb_log_files_in_group = 2


xtrabackup:  innodb_log_file_size = 268435456


>> log scanned up to (619371504)


[01] Copying/usr/local/mysql/var/ibdata1 to /backup/full_data/2017-04-04_13-28-58/ibdata1


>> log scanned up to (619371504)


.......................


>> log scanned up to (619371544)



[01]      ...done


>> log scanned up to (619371544)


xtrabackup: Creating suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_suspended_2' with pid '26398'


170404 13:29:13 innobackupex: Continuing after ibbackup has suspended


170404 13:29:13 innobackupex: Starting to lock all tables...


>> log scanned up to (619371544)


170404 13:29:13 innobackupex: All tables locked and flushed to disk


170404 13:29:13 innobackupex: Starting to backup non-InnoDB tables and files


innobackupex: in subdirectories of '/data/mysql/'


innobackupex: Backing up files'/data/mysql//mahtu/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(747 files)


>> log scanned up to (619371544)


...............



>> log scanned up to (619371544)


170404 13:29:19 innobackupex: Finished backing up non-InnoDB tables and files


170404 13:29:19 innobackupex: Waiting for log copying to finish


xtrabackup: The latest check point (forincremental): '619371544'


xtrabackup: Stopping log copying thread.


.>> log scanned up to (619371544)


xtrabackup: Creating suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_log_copied' with pid '26398'


xtrabackup: Transaction log of lsn (619371135) to(619371544) was copied.


170404 13:29:20 innobackupex: All tables unlocked


innobackupex: Backup created in directory'/backup/full_data/2017-04-04_13-28-58'


innobackupex: MySQL slave binlog position: masterhost '192.168.10.20', filename 'mysql-bin.000001', position 35593612


170404 13:29:20 innobackupex: Connection to database server closed


170404 13:29:20 innobackupex: completed OK!


real  0m25.738s


user 0m2.765s


sys  0m3.927s


备份数据恢复的报错提示:


[root@localhost 2017-04-04_16-04-46]#innobackupex --defaults-file=/etc/my.cnf --copy-back  /backup/dk_data/2017-0

首页 上一页 1 2 3 4 5 下一页 尾页 4/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇数据库中间件之Middleware 下一篇关于MySQL数据库的备份方案

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目