I accidentally installed MySQL 8 and did a ton of work there, creating a lot of data. I then backed up all of the databases using mysqldump.
Later, I realized that I needed to downgrade back to MySQL 5.7 (after not even having realized that I'd upgraded).
I've uninstalled 8 and installed 5.7, but I've been having trouble importing my data from the .sql file from the dump.
First, I got the error
ERROR 1273 (HY000) at line 1753: Unknown collation: 'utf8mb4_0900_ai_ci', which I solved by using Notepad++ to replace:
Then I also deleted the section of the .sql file related to the 'mysql' database.
Now the command
mysql < alldb.sql runs without error, but when I go look at my data, a lot of it is missing.
P.S. I feel optimistic that someone can help me, but it's a bit worrying that MySQL 8 docs say:
Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you backup your data before starting the upgrade process.