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?
Only use --all-databases when you are doing a backup that will only ever be restored to the exact same version of MySQL
- RiggsFolly
If you did something like this then you don't have any option if you uninstalled mysql 8 after you took backup.
What you can do is first take backup with --all-databases for fresh 5.7 mysql. Then restore from mysql 8 dump. At the end again restore from 5.7 mysql original dump you took first.
mysqldump -uroot -p<password> --all-databases > mysql_5.7_default.sql
mysql -uroot -p<password> < dump_from_mysql_8.sql
mysql -uroot -p<password> < mysql_5.7_default.sql