Trouble importing SQL database of my site

[asakoshe]

I have recently moved my site over from 000webhost.com to this service. Before moving, I have downloaded the entire FTP content, and exported an SQL file of my database. In this service, I have uploaded back my FTP files, but I can't upload back the SQL file to PHPMyAdmin. My site is based on Wordpress, and I am given this error message when I try uploading the SQL file:
Error
SQL query:

--
-- Database: `asakoshe_asa`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_commentmeta`
--
-- Creation: Oct 10, 2012 at 07:17 AM
-- Last update: Aug 29, 2013 at 11:47 AM
--
CREATE TABLE `wp_commentmeta` (

`meta_id` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`comment_id` bigint( 20 ) unsigned NOT NULL DEFAULT '0',
`meta_key` varchar( 255 ) DEFAULT NULL ,
`meta_value` longtext,
PRIMARY KEY ( `meta_id` ) ,
KEY `comment_id` ( `comment_id` ) ,
KEY `meta_key` ( `meta_key` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =5;

MySQL said:

#1046 - No database selected

Help would be most appreciated

 

[Anna]

You need to create the database to witch you want to import the data first, this is done in the control panel, where you also would sort a user for the database to later use in the configuration file for wordpress.

Once you have done so, go to phpMyAdmin and select the database and then import your data into that database.

 

[asakoshe]

I have already done so, this message is shown after I have done all this.

 

[descalzo]

When you are in phpMyAdmin, make sure you select the new database first, and then import the data.

 

[asakoshe]

thank you that solved my problem