Error when importing sql database to phpmyadmin

Question

I'm having trouble when trying to import a database into phpmyadmin.

Error
SQL query:

--
-- Database: `iiumcms`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS  `admin` (

 `fname` VARCHAR( 50 ) NOT NULL ,
 `email` VARCHAR( 50 ) NOT NULL ,
 `admin_no` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `dept_id` VARCHAR( 15 ) NOT NULL ,
 `username` VARCHAR( 30 ) NOT NULL ,
 `password` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY (  `admin_no` )
) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =7;

MySQL said: Documentation

#1046 - No database selected 

Answer 1

You have to create an empty database with name 'iiumcms' in your PhpMyAdmin and have to select this database in left sidebar before importing your .sql file.

Answer 2

You have to first select your database, then import file.

In MySQL you can use this statement:

USE `iiumcms`;

If you don't have this database created, you have to do it first.