Import mysql error


#1

Hi,
I have this .sql file to import.
I know how it works, have done it many times.

Now I got the .sql file, but it gives an error and I do not know why.
It is error 1046 no database selected.

It only happens for the first table, because if I delete the first table (below) from the .sql file the other tables are created without any problems.

Here is the part that gives the error:
[php]-- Creating table for countries
CREATE TABLE countries (
id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
country varchar(64) DEFAULT NULL,
flag text NOT NULL,
country_code char(2) DEFAULT NULL,
KEY idx_country_name (country)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

– Dumping data for countries
INSERT INTO countries (country, flag, country_code) VALUES
(‘Afghanistan’, ‘Afghanistan-Flag.png’, ‘AF’),(‘Albania’, ‘Albania-Flag.png’, ‘AL’),(‘Algeria’, ‘Algeria-Flag.png’, ‘DZ’),(‘American Samoa’, ‘American-Samoa-Flag.png’, ‘AS’),
I will spare you the rest of the countries list to be added.[/php]