Fix for ERROR 1049 (42000): Unknown database…
I was trying to import a new database but kept getting this error ERROR 1049 (42000): Unknown database ‘MYDATABASE’, finally got it fixed… the error wasn’t with the syntax it was how I exported my database.
When I exported my database from phpmyadmin, I selected the main database rather than the individual tables. So in phpMyAdmin you’ll want to click on your database in the left column first.
Then click Export along the top tabs.
Select All tables in the database.
Check off the box for Structure and the following:
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Check the box for data and the following:
Maximal length of created query
Use hexadecimal for BLOB
Select “Insert” from drop box.
Check off the box “Save As File” and give your file a name, I like to use an uncompressed version of my database so I’m going to select “none” for that.
Press “Go” and you’ll see the SQL file start to download.