Shulou(Shulou.com)06/01 Report--

Problem description:

MYSQL5.7.22 full library backup file is imported into MYSQL8.0.20 library and ERROR3554 error is reported.

Error message:

ERROR 3554 (HY000) at line 404: Access to system table 'mysql.innodb_index_stats' is rejected.

Online description:

Https://bugs.mysql.com/bug.php?id=92675

Description:

According to the description of the information on the Internet, the problem I encountered can be solved by ignoring the backup of 2 system tables, but after personal testing, this solution is not feasible.

The error is still reported.

The test process is as follows:

Solution:

1. Back up 5.7.22 in a single library and import it to the 8.0.20 version library, which can be effective.

For example:

Mysqldump-uroot-paired rooms * testdb > / opt/testbak20200603.dmp

2. Back up 5.7.22 of the whole library and import it into the same version library of 5.7.22, which can be effective.

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.