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

This article will explain in detail how to restore 5.7.12 backup to 5.7.17 in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Restore the backup of 5.7.12 to 5.7.17, and after starting the database, you encounter an error, as follows:

2017-02-09T08:01:58.275817Z 0 [ERROR] Info table has a problem with its key field (s). Table 'mysql.slave_master_info' expected field # 23 to be' Channel_name' but found 'Tls_version' instead.

2017-02-09T08:01:58.279951Z 0 [ERROR] Incorrect definition of table performance_schema.replication_connection_status: expected column 'RECEIVED_TRANSACTION_SET' at position 7 to have type longtext

, found type text.

2017-02-09T08:01:58.280237Z 0 [ERROR] Incorrect definition of table performance_schema.replication_group_member_stats: expected column 'COUNT_TRANSACTIONS_ROWS_VALIDATING' at position 6, found' CO

UNT_TRANSACTIONS_VALIDATING'

The reason for the error is that after upgrading to 5.7.17, the structure of some tables has changed, which can be repaired by executing the mysql_upgrade command. This is the end of the article on "what to do when you restore the backup of 5.7.12 to 5.7.17 in mysql". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.