I have an archive with wp-content folder + the .sql file from a site I want to import.
I create a site from the archive and it looks like it goes through the process but when its finished no database was imported and wp-content is just the basic.
The easiest way to fix the utf8mb4 error is to simply use MySQL 5.6 since it’s supported in MySQL 5.6.
We’re working on improving prefix detection in an upcoming update. In the meantime you can simply match $table_prefix to the appropriate prefix. You can use Adminer or Sequel Pro to see all of your tables with one click.
If you don’t mind, can you try importing this again and then send the local-by-flywheel.log file? You can find it by going to Help » Reveal Local’s Log (macOS) or by clicking the menu icon in the top left and clicking Reveal Local’s Log (Windows).