Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to deal with the problems after mysql 5.1L 5.6upgrade

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly shows you "mysql 5.1L 5.6upgrade after the problem how to deal with", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql 5.1L 5.6upgrade after the problem how to deal with" this article.

Error: 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)

The developer installed a mysql on his own yum on the test machine. at present, the mysql version of centos's yum is 5.1, which is 5.6.20 online. So。 Wipe your ass. Upgrade the testing machine.

The process of installing 5.6.20 ignores..

Mysqldump export data:

Mysql-e "show databases;"-uroot-p | grep-Ev "Database | information_schema | mysql | test | performance_schema" | xargs mysqldump-uroot-p-databases > mysql51.sql

Importing data.

I directed the library ps:mysql separately. At first, I thought that the version was different and there might be differences, so I guided it separately in case of failure.

The whole process went smoothly, and later, when I was doing the backup script, there was a problem.

[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)

I can't sleep until I find out the problem. Although mysqldump exports sql files, the table structure and view information in mysql library is still 5.1 structure. So you need to execute the upgrade script.

Enter the mysql 5.6 installation directory:

[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] #

These are all the contents of this article entitled "how to deal with problems after mysql 5.1L 5.6upgrade". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 298

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report