设为首页 加入收藏

TOP

MySQL Study之--Percona Server 5.5升级5.6(四)
2015-12-15 22:18:19 来源: 作者: 【 】 浏览:55
Tags:MySQL Study --Percona Server 5.5 升级 5.6
umping routines for database 'test'


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;


/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;


/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


-- Dump completed on 2015-12-03 12:31:52


3)、停止数据库


[root@cent65 mysql]# service mysql stop
Shutting down MySQL (Percona Server).......[? OK? ]
[root@cent65 mysql]# mv /var/lib/mysql /var/lib/mysql55


4)、 移动旧数据库(5.5版本)的数据目录(假设是/var/lib/mysql,此处应该改为你自己的数据目录)


[root@cent65 mysql]#mv /var/lib/mysql /var/lib/mysql55


[root@cent65 mysql]#mkdir /var/lib/mysql


[root@cent65 mysql]#chown -R mysql:mysql /var/lib/mysql


三、安装Percona Server 5.6


[root@cent65 percona-56]# ls -l
total 121104
-rwxr-xr-x. 1 mysql mysql 70389368 Dec? 3 11:21 Percona-Server-56-debuginfo-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql? 6727084 Dec? 3 11:21 Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql? 1031588 Dec? 3 11:21 Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql 20463420 Dec? 3 11:21 Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql? 742496 Dec? 3 11:21 Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql 23137340 Dec? 3 11:21 Percona-Server-test-56-5.6.25-rel73.1.el6.x86_64.rpm
-rwxr-xr-x. 1 mysql mysql? 1508480 Dec? 3 11:21 Percona-Server-tokudb-56-5.6.25-rel73.1.el6.x86_64.rpm


Percona server 5.5会与5.6的软件有冲突,所以5.6的安装需要强制安装:
[root@cent65 percona-56]# rpm -ivh Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm --force
warning: Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...? ? ? ? ? ? ? ? ########################################### [100%]
? 1:Percona-Server-shared-5########################################### [100%]


[root@cent65 percona-56]# rpm -ivh Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm --force --nodeps
warning: Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...? ? ? ? ? ? ? ? ########################################### [100%]
? 1:Percona-Server-client-5########################################### [100%]


[root@cent65 percona-56]# rpm -ivh Percona-Server-test-56-5.6.25-rel73.1.el6.x86_64.rpm --force --nodeps
warning: Percona-Server-test-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...? ? ? ? ? ? ? ? ########################################### [100%]
? 1:Percona-Server-test-56 ########################################### [100%]


[root@cent65 percona-56]# rpm -ivh Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm --force --nodeps
warning: Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...? ? ? ? ? ? ? ? ########################################### [100%]
? 1:Percona-Server-devel-56########################################### [100%]


server软件的安装需要先卸载server 5.5:


1)、卸载server 5.5
[root@cent65

首页 上一页 1 2 3 4 5 6 7 下一页 尾页 4/7/7
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇让MySQL 5.6支持Emoji表情 下一篇MySQL 增量备份的脚本 (innoback..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: