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 ProUpon 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: ErrorSQL query:-- Database: myfirstdatabase1046 - No database selectedI have clearly gone about backing up my databases in the wrong way, but is there a method for easily recovering from this situation?
How do I solve this error when importing MySQL databases into phpMyAdmin?
mysql;phpmyadmin