As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their respective tables.
My setup is a MacBook running MAMP 3 Pro
Upon trying to restore the databases, I am running into a problem where phpMyAdmin seems to want the each of the databases to be created first. A typical error message is:
Error SQL query:
1046 - No database selected
I have clearly gone about backing up my databases in the wrong way, but is there a method for easily recovering from this situation?