• Hi everyone..

    I am attempting to transfer my site to my host and have taken the following steps:

    1) I have exported the mysite.sql database and saved as a text file (sql).

    2) I have changed the http://localhost/mysite occurrences with http://www.mysite.com, so that hte paths to all documents are correct

    3) I also have chanched C:\wamp\www\mysite\blog\wp-content\uploads
    with /wp-content/uploads

    However, when I go to import the sql file into phpmyadmin I get the following error:

    Error
    SQL query:


    — Database: ososantoso

    — ——————————————————–

    — 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 ) DEFAULT NULL ,
    meta_value LONGTEXT,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

    MySQL said:

    #1046 – No database selected

    help me please.. what should i do?

Viewing 4 replies - 16 through 19 (of 19 total)
Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Error when importing sql database to phpmyadmin’ is closed to new replies.