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

Today, I will talk to you about how to restore the MySQL5.7 environment to the database of 5.1. many people may not understand it very well. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

5.7 environment restore 5.1 data

Mysqldump reported an error

At this point, you need to deal with it in the following ways

Mysqldump-u root-p hscom_bzjjy-- set-gtid-purged=OFF > hscom_bzjjy.sql

The following error occurred

Mysqldump: Couldn't execute 'SHOW VARIABLES LIKE' ndbinfo\ _ version'': Table 'performance_schema.session_variables' doesn't exist (1146)

Treatment method

Mysql_upgrade-u root-p-- force

Then restart the service

And then it can be exported.

After reading the above, do you have any further understanding of how to restore the MySQL5.7 environment to the database of 5.1? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.