Receiving an error when moving table from one server to the other

Question

I am trying to move a Wordpress table from my old server to my new one and I am receiving this error: SQL query:

--
-- Database: `username_film`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `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` ) ,
KEY `disqus_dupecheck` ( `meta_key` , `meta_value` ( 11 ) )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1277;

MySQL said: Documentation
#1046 - No database selected 

So, on my old server, I went into phpmyadmin and exported the wordpress table (not the entire server database) in SQL format, then went into my new server and uploaded it through import. What am I doing wrong? Please note that I am not very experienced with database administration so details in answers would be very helpful!

Answer 1

You have to create and/or use a specific database where this table is supposed to be imported!