ERROR 1726 (HY000): Storage engine \'InnoDB\' does not support system tables. [mysql.columns_priv]

Read-only archive. These discussions are from Tracston's earlier technical forum and are kept online because the answers are still useful. New replies are closed. Need help with something like this? Talk to us.

Question 7 Aug 2022

Problem

User gets this error when trying to import a MySQL exported database

mysql -u root -p -h 127.0.0.1 < all_databases.db

ERROR 1726 (HY000) at line 41: Storage engine 'InnoDB' does not support system tables. [mysql.columns_priv]

Solution

This error occurs due to database incompatibility for example exporting all databases from MySQL version 8 and trying to import it to Version 5.7

There are 2 options to resolve it

Export the database without specifying --all-databases
change engine from InnoDB to MyISAM

Need this fixed properly?

We do this for a living.

Kubernetes, DevOps and platform engineering, delivered in days — not another weekend lost to a stack trace.

Start a project →