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

author

Dev

. min read

Follow

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