mysql 迁移9

franket

发布于 2022-03-21 18:45:57

1.5K0

发布于 2022-03-21 18:45:57

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

恢复数据

[root@slave01 data]# time nohup /usr/bin/innobackupex --copy-back /data/nfs/test_full_backup/2015-12-09_00-53-03/ >> restore.log  2>&1   &  
[1] 12635
[root@slave01 data]# 
[root@slave01 data]# tail -f restore.log 
...
...

要确保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 以确认

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

ssh