mysql 5.1升5.6 升級(jí)后出現(xiàn)問(wèn)題怎么處理

這篇文章主要為大家展示了“mysql 5.1升5.6 升級(jí)后出現(xiàn)問(wèn)題怎么處理”，內(nèi)容簡(jiǎn)而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“mysql 5.1升5.6 升級(jí)后出現(xiàn)問(wèn)題怎么處理”這篇文章吧。

錯(cuò)誤:mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'born_CRM'': Cannot load from mysql.proc. The table is probably corrupted (1728)
Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mysql'': Cannot load from mysql.proc. The table is probably corrupted (1728)





開(kāi)發(fā)在測(cè)試機(jī)上自己yum安裝了一個(gè)mysql,目前centos的yum中的mysql版本是5.1,線(xiàn)上都5.6.20了....所以.擦屁股唄....升級(jí)測(cè)試機(jī).

安裝5.6.20 過(guò)程就忽略了..
mysqldump 導(dǎo)出數(shù)據(jù):
mysql -e "show databases;" -uroot -p| grep -Ev "Database|information_schema|mysql|test|performance_schema" | xargs mysqldump -uroot -p --databases > mysql51.sql

在導(dǎo)入數(shù)據(jù).
ps:mysql這個(gè)庫(kù)我是單獨(dú)導(dǎo)的,一開(kāi)始我想的是,版本不一樣,可能存在差異,所以,就單獨(dú)導(dǎo),以防失敗.

整個(gè)過(guò)程都很順利,后來(lái)做備份腳本的時(shí)候,發(fā)生問(wèn)題了.....
[root@localhost dbbackup]# ./backup.sh
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'born_CRM'': Cannot load from mysql.proc. The table is probably corrupted (1728)
Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mysql'': Cannot load from mysql.proc. The table is probably corrupted (1728)



輾轉(zhuǎn)反側(cè)才發(fā)現(xiàn)問(wèn)題所在,雖然mysqldump導(dǎo)出的是sql文件,但是mysql庫(kù)中的表結(jié)構(gòu),視圖等信息,仍然還是5.1的結(jié)構(gòu).所以需要執(zhí)行升級(jí)腳本.
進(jìn)入mysql 5.6安裝目錄:
[root@localhost ~]# cd /opt/mysql3307/bin/
[root@localhost bin]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
[root@localhost bin]# mysql_upgrade  -uroot -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
.
.
.
.
yrd_e8trunk_zyl.user_origin                        OK
yrd_e8trunk_zyl.user_password_extend               OK
yrd_e8trunk_zyl.user_points                        OK
yrd_e8trunk_zyl.user_points_detail                 OK
yrd_e8trunk_zyl.user_relation                      OK
yrd_e8trunk_zyl.user_role                          OK
OK
[root@localhost bin]#
[root@localhost bin]#

以上是“mysql 5.1升5.6 升級(jí)后出現(xiàn)問(wèn)題怎么處理”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對(duì)大家有所幫助，如果還想學(xué)習(xí)更多知識(shí)，歡迎關(guān)注億速云行業(yè)資訊頻道！