• Resolved ripharris

    (@ripharris)


    Hi guys,
    I’ve recently switched from one hosting company to another. I used WP online backup to backup all data from the old account. I’ve renamed everything on the new server as before so WP resides in the same folder with the username and password.

    I’ve uploaded the files from the old server into the folder on the new server but as I understand it I need to upload the database now. I’ve tried to import the database using MySqladmin but I will admit that I have zero experience of database end stuff.

    I would greatly appreciate if somebody could talk me through how I go about getting the new site back up and running. I have tried for a few days myself, but have had no joy.

    Here’s the last error I got in MySql:
    Error
    SQL query:

    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 AUTO_INCREMENT =673DEFAULT CHARSET = latin1;

    MySQL said:

    #1046 – No database selected

    Any help would be hugely appreciated guys and gals.

    Many thanks in advance.

    http://wordpress.org/extend/plugins/wponlinebackup/

Viewing 1 replies (of 1 total)
  • Plugin Author Online Backup

    (@driskell)

    Hi ripharris,

    In phpMyAdmin you need to select one of the databases before you import the SQL.

    Click the database you want to restore to on the left hand side.
    Then click the SQL tab on the right and you should be able to browse to the file.

    You may need to create the database in your control panel first, or create it with phpMyAdmin by clicking Create new database on the home page. (If it says No Privileges next to Create new database you will most likely have to create the table using your control panel instead.)

    Regards,

    Jason.

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: Online Backup for WordPress] MySql problem’ is closed to new replies.