Database Errors While Moving from localhost to webhost

I am trying to move my site to my webhost. I have downloaded the database and edited it to direct to my new URL. When I go to import the database, I get these errors:
Error
SQL query:

—
— Database: tranquility
—
— ——————————————————–
—
— Table structure for table tran_assets
—
CREATE TABLE IF NOT EXISTS tran_assets (

id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘Primary Key’,
parent_id INT( 11 ) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set parent.’,
lft INT( 11 ) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set lft.’,
rgt INT( 11 ) NOT NULL DEFAULT ‘0’ COMMENT ‘Nested set rgt.’,
level INT( 10 ) UNSIGNED NOT NULL COMMENT ‘The cached level in the nested tree.’,
name VARCHAR( 50 ) NOT NULL COMMENT ‘The unique name for the asset.\n’,
title VARCHAR( 100 ) NOT NULL COMMENT ‘The descriptive title for the asset.’,
rules VARCHAR( 5120 ) NOT NULL COMMENT ‘JSON encoded access control.’,
PRIMARY KEY ( id ) ,
UNIQUE KEY idx_asset_name ( name ) ,
KEY idx_lft_rgt ( lft , rgt ) ,
KEY idx_parent_id ( parent_id )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =174;

MySQL said:

#1046 – No database selected

I hope someone can help me..thanks in advance