• Hello all
    I’m trying to import a SQL format database onto my web hosting.
    After successfully exporting it from phpMyAdmin as ‘filename.sql.zip’ the server import process returns the following error message:
    ‘Error
    SQL query:

    — Database: groundg
    — ——————————————————–
    — Table structure for table wp_commentmeta
    CREATE TABLE wp_commentmeta (

    meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT ‘0’,
    meta_key VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    meta_value LONGTEXT COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key ( 191 ) )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci AUTO_INCREMENT =1;

    MySQL said: Documentation

    #1046 – No database selected’
    ——————————————————————-
    The error code is at the end.
    Could someone interpret this issue for me thanks?

Viewing 4 replies - 1 through 4 (of 4 total)
  • You’ll need to create a database on your hosting account to import the data to. Generally the import won’t do this for you. If you’re using cPanel, go to MySQL Databases and create a database. Then go to PHPMyAdmin, and find the database on the left. Select that then select import and upload the file.

    You will also need to create a database USER, confusingly this is undet the PRIVILEGES tab of phpmyadmin. Add a user, grant it ALL privileges on the database. THEN edit your wp-config.php file so that it correctly names your DATABASE + DatabaseUSER + PASSWORD.

    On your localhost where you created your website, the database was named “groundg”, on your hosting the name will be longer, it will have a prefix that is your hosting username, this does not matter, but be sure to fill in the whole names in your wp-config.php file.

    Thread Starter redrock2rock

    (@redrock2rock)

    Thanks both.
    I’ll get to that and give feedback.
    Cheers!!

    hi folks,

    in case others have had this issue the fix suggested in this stack overflow by Evster worked for me

    http://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘database wont import to ISP server’ is closed to new replies.