要确保mysql 数据库的 datadir是清空的,否则会报错
[root@slave02 data]# cat restore.log
nohup: ignoring input
Warning: option 'innodb_autoextend_increment': unsigned value 33554432
adjusted to 1000
151209 02:40:21 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
/usr/bin/innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux
(x86_64) (revision id: 306a2e0)
Original data directory /var/lib/mysql is not empty!
nohup: ignoring input
Warning: option 'innodb_autoextend_increment': unsigned value 33554432
adjusted to 1000
151209 02:41:08 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
/usr/bin/innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux
(x86_64) (revision id: 306a2e0)
Original data directory /var/lib/mysql is not empty!
[root@slave02 data]#
一般而言,rm -rf *
并不会删除以 .
开头的文件 如: .bash_history .lesshst .mysql_history .viminfo
要指明删,如 rm -rf .bash_history .lesshst .mysql_history .viminfo
或 rm -rf .*
使用 ls -a
以确认
[root@slave02 data]# watch -n 2 du -sh /data/mysql/
每两秒看一下数据目录大小
151209 03:57:34 [01] Copying ./mysqltestt_db/kqmobile_payments.ibd to
/var/lib/mysql/mysqltestt_db/kqmobile_payments.ibd
151209 03:57:34 [01] ...done
151209 03:57:34 [01] Copying ./mysqltestt_db/member_orders.frm to
/var/lib/mysql/mysqltestt_db/member_orders.frm
151209 03:57:34 [01] ...done
151209 03:57:34 [01] Copying ./mysqltestt_db/smsg_runner_logs.ibd to
/var/lib/mysql/mysqltestt_db/smsg_runner_logs.ibd
151209 03:57:34 [01] ...done
151209 03:57:34 completed OK!
real 73m17.260s
user 0m0.782s
sys 19m4.516s
^C
[1]+ Done time nohup /usr/bin/innobackupex --copy-back
/data/nfs/test_full_backup/2015-12-09_00-53-03/ >> restore.log 2>&1
[root@slave02 data]#
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。