1. 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...

    .
     
    Last edited: Aug 14, 2013
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You have to open the database in phpmyadmin first were you want ti omport the sql file before you go to the import menu.
     

Share This Page