How do I export database to webserver?

[klemme]

Hi All!

I have made a small cms using php and mysql - I havent tried to export a databae to a webserver before, so I need a little help/confirmation.

When I click export in phpmyadmin, and chooses type to be SQL, and saves it with the allready chosen/marked boxes, and export it as insert...

....Have I then done it the correct way, so I can use the small SQL file (Upload that SQL file with the rest of the php files), to create a similar database on the production server?

Regards,

Klemme

[klemme]

I get this error when I try to import the SQL file:

localhost
Fejl
SQL-forespørgsel:

--
-- Database: `oikos`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `customers`
--
CREATE TABLE IF NOT EXISTS  `customers` (

 `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `navn` VARCHAR( 255 ) CHARACTER SET utf8 NOT NULL ,
 `adresse` VARCHAR( 255 ) CHARACTER SET utf8 NOT NULL ,
 `telefon` INT( 11 ) NOT NULL ,
 `email` VARCHAR( 255 ) CHARACTER SET utf8 NOT NULL ,
 `udmark` VARCHAR( 255 ) CHARACTER SET utf8 NOT NULL ,
 `skind` INT( 11 ) NOT NULL ,
 `pris` INT( 11 ) NOT NULL ,
 `kontaktet` VARCHAR( 255 ) CHARACTER SET utf8 NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =35;

MySQL returnerede: 

#1046 - No database selected

Anyone who knows how I can import this file properly??

Klemme

[debasisdas]

Read this and this for Exporting of mysql