Search code examples
mysqlraspberry-pimysql-5.7mysql-8.0

Mysql - Error 1726 (HY000) at line...: Storage engine 'InnoDB' does not support system tables

I am trying to export a database without data from mysql 8 to myqsl 5.7 and I am getting the following error:

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

The mysql 5.7 server is on a raspberry pi 3 b+, if that is of any significance.

To create the dump i did this:

mysqldump -u root -p --no-data --all-databases > all_databases.sql

How do I fix this?

Solution

  • Only use --all-databases when you are doing a backup that will only ever be restored to the exact same version of MySQL - RiggsFolly