MySQL Workbench Import/Restore: "There were no dump files in the selected folder."
in Development
When exporting from phpMyAdmin, there is an option to *Export tables as separate files*. However, importing the resulting dump as a single zip results in PMA importing only a few tables, and then aborting even if you disable the *Allow the interruption of an import* option. And MySQL Workbench won't recognise the folder as a backup either:
> There were no dump files in the selected folder.
- Take your archive and unzip/uncompress it into a folder. The folder will now contain all of your tables as well as `_database.sql` and `_extra.sql` on top of the list.
- Rename the `_extra.sql` so that it becomes the last file in the folder listing. It contains indexes and other information that applies to the database only after all of the tables had been created by running the instructions in the previous files.
- Merge all of the files together as recommended [in this answer](https://stackoverflow.com/questions/9000147/how-to-easily-import-multiple-sql-files-into-a-mysql-database):
```
cat *.sql > .all_files.sql
```