mysql 迁移9

franket

发布于 2022-03-22 14:23:08

1.4K0

发布于 2022-03-22 14:23:08

文章被收录于专栏：技术杂记

要确保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 删除。

ssh