phpMyadmin database import error #1046 - No database selected

Question

I have an sql file that i exported from phpmyadmin on another computer. I tried to import the file on this computer and I get this error:

Error 

SQL query:

-- -- Database: `phplogin` -- -- -------------------------------------------------------- -- -- Table structure for table `people` -- CREATE TABLE IF NOT EXISTS  `people` (   `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,  `name` VARCHAR( 25 ) NOT NULL ,  `age` INT( 11 ) NOT NULL ,  `testvar` VARCHAR( 5 ) NOT NULL , PRIMARY KEY (  `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =3;  MySQL said:   #1046 - No database selected  

Answer 1

The error is because you either didn't select a database on the left side to import to, and/or you didn't create the empty database first. Create a database in phpMyAdmin called "phplogin", select it on the left side, and then run the import.

Answer 2

Append the following line to the beginning of your sql file

CREATE DATABASE phplogin; 

These problems can be resolved by exporting the SQL file while being outside the database.Then phpmyadmin automatically appends the above statement to the SQL file