首页
学习
活动
专区
圈层
工具
发布
社区首页 >专栏 >mysql 5.1升级到5.65

mysql 5.1升级到5.65

作者头像
franket
发布2022-04-16 17:45:08
发布2022-04-16 17:45:08
4460
举报
文章被收录于专栏:技术杂记技术杂记

恢复数据

代码语言:javascript
复制
[root@upgrade-slave nfs]# time nohup  innobackupex  --copy-back  masterdb.full.backup/2015-11-25_21-25-02/  >> /tmp/fullcopyback.log  2>&1   & 
[1] 117341
[root@upgrade-slave nfs]# 
[root@upgrade-slave nfs]# tail -f /tmp/fullcopyback.log   
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/mysql/general_log.CSV' to '/var/lib/mysql/mysql/general_log.CSV'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/mysql/func.MYI' to '/var/lib/mysql/mysql/func.MYI'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/mysql/time_zone_leap_second.MYD' to '/var/lib/mysql/mysql/time_zone_leap_second.MYD'
innobackupex: Creating directory '/var/lib/mysql/key_db'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/key_db/user_connections.ibd' to '/var/lib/mysql/key_db/user_connections.ibd'
...
...
innobackupex: Starting to copy InnoDB log files
innobackupex: in '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02'
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/ib_logfile1' to '/var/lib/mysql/ib_logfile1'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/ib_logfile2' to '/var/lib/mysql/ib_logfile2'
innobackupex: Copying '/data/nfs/masterdb.full.backup/2015-11-25_21-25-02/ib_logfile0' to '/var/lib/mysql/ib_logfile0'
innobackupex: Finished copying back files.

151126 20:41:40  innobackupex: completed OK!

real	33m3.933s
user	0m0.963s
sys	4m54.254s


[1]+  Done                    time nohup innobackupex --copy-back masterdb.full.backup/2015-11-25_21-25-02/ >> /tmp/fullcopyback.log 2>&1
[root@upgrade-slave nfs]#

修改权限

代码语言:javascript
复制
[root@upgrade-slave ~]# cd /var/lib/mysql/
[root@upgrade-slave mysql]# ls
huodongdb  something_more  ib_logfile0  istuffdb    mysql        feeddb
historydb   stuffdb      ib_logfile1  caldb    mytempdb      test
testdb    ibdata1      ib_logfile2  mupgradetest_pd  key_db  xtrabackup_binlog_pos_innodb
[root@upgrade-slave mysql]# ll 
total 5916788
drwxr-xr-x. 2 root root       4096 Nov 26 20:10 huodongdb
drwxr-xr-x. 2 root root       4096 Nov 26 20:12 historydb
drwxr-xr-x. 2 root root      53248 Nov 26 20:41 testdb
drwxr-xr-x. 2 root root       4096 Nov 26 20:18 something_more
drwxr-xr-x. 2 root root       4096 Nov 26 20:11 stuffdb
-rw-r--r--. 1 root root 5253365760 Nov 26 20:41 ibdata1
-rw-r--r--. 1 root root  268435456 Nov 26 20:41 ib_logfile0
-rw-r--r--. 1 root root  268435456 Nov 26 20:41 ib_logfile1
-rw-r--r--. 1 root root  268435456 Nov 26 20:41 ib_logfile2
drwxr-xr-x. 2 root root       4096 Nov 26 20:11 istuffdb
drwxr-xr-x. 2 root root      12288 Nov 26 20:18 caldb
drwxr-xr-x. 2 root root       4096 Nov 26 20:18 mupgradetest_pd
drwxr-xr-x. 2 root root       4096 Nov 26 20:08 mysql
drwxr-xr-x. 2 root root       4096 Nov 26 20:10 mytempdb
drwxr-xr-x. 2 root root       4096 Nov 26 20:10 key_db
drwxr-xr-x. 2 root root       4096 Nov 26 20:11 feeddb
drwxr-xr-x. 2 root root       4096 Nov 26 20:11 test
-rw-r--r--. 1 root root         29 Nov 26 20:08 xtrabackup_binlog_pos_innodb
[root@upgrade-slave mysql]# cd ..
[root@upgrade-slave lib]# chown  -R mysql.mysql /var/lib/mysql/
[root@upgrade-slave lib]# ll /var/lib/mysql/
total 5916788
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:10 huodongdb
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:12 historydb
drwxr-xr-x. 2 mysql mysql      53248 Nov 26 20:41 testdb
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:18 something_more
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:11 stuffdb
-rw-r--r--. 1 mysql mysql 5253365760 Nov 26 20:41 ibdata1
-rw-r--r--. 1 mysql mysql  268435456 Nov 26 20:41 ib_logfile0
-rw-r--r--. 1 mysql mysql  268435456 Nov 26 20:41 ib_logfile1
-rw-r--r--. 1 mysql mysql  268435456 Nov 26 20:41 ib_logfile2
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:11 istuffdb
drwxr-xr-x. 2 mysql mysql      12288 Nov 26 20:18 caldb
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:18 mupgradetest_pd
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:08 mysql
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:10 mytempdb
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:10 key_db
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:11 feeddb
drwxr-xr-x. 2 mysql mysql       4096 Nov 26 20:11 test
-rw-r--r--. 1 mysql mysql         29 Nov 26 20:08 xtrabackup_binlog_pos_innodb
[root@upgrade-slave lib]#

启动服务

本文系转载,前往查看

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

本文系转载前往查看

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

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 恢复数据
  • 修改权限
  • 启动服务
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档