New ISPconfig 3 Server/Ubuntu Server 12.04.2 Database PhpMyAdmin Backup/Restore Fails

Hi,


After setting up a new ISPconfig server I made a backup of a database from a client... No problems in making the backup via PhpMyAdmin.. But when I tried to "Import" it to the new ISPconfig server using PhpMyAdmin I got this error:

Fejl (error in english)

SQL-forespørgsel: (sql-query in english)

--
-- Database: `c1shop`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `address_book`
--
CREATE TABLE IF NOT EXISTS `address_book` (
`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL ,
`entry_gender` char( 1 ) NOT NULL ,
`entry_company` varchar( 64 ) DEFAULT NULL ,
`entry_vat_number` varchar( 64 ) NOT NULL ,
`entry_ean_number` varchar( 64 ) NOT NULL ,
`entry_firstname` varchar( 32 ) NOT NULL ,
`entry_lastname` varchar( 32 ) NOT NULL ,
`entry_street_address` varchar( 64 ) NOT NULL ,
`entry_suburb` varchar( 32 ) DEFAULT NULL ,
`entry_postcode` varchar( 10 ) NOT NULL ,
`entry_city` varchar( 32 ) NOT NULL ,
`entry_state` varchar( 32 ) DEFAULT NULL ,
`entry_country_id` int( 11 ) NOT NULL DEFAULT '0',
`entry_zone_id` int( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id` ( `customers_id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =7;

MySQL returnerede: Dokumentation
#1046 - No database selected

I DID chose the database when eksporting and when importing theres only a file to choose. Not a databse

SOS....


------------------
PROBLEM SOLVED!
------------------

Dont delete the entire database when trying to eksport/import a database from an old webserver to a new webserver. Delete only "Tables". Then it will work...

.