ERROR 3554 (HY000) while importing a .sql dump file

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

You'll need to make a new dump/backup of your old database, Remove innodb tables from your target.
You can do this by using-- ignore-table parameter on the command line:

mysqldump -u root -p --all-databases --ignore-table=mysql.innodb_index_stats --ignore-table=mysql.innodb_table_stats > db_backup.sql

Restore your backup on the new database using the command below:

mysql -u root -p < db_backup.sql


Dev
Written By

Dev

The Dev

You may also like