Title: [Plugin: Online Backup for WordPress] MySql problem
Last modified: August 20, 2016

---

# [Plugin: Online Backup for WordPress] MySql problem

 *  Resolved [ripharris](https://wordpress.org/support/users/ripharris/)
 * (@ripharris)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-online-backup-for-wordpress-mysql-problem/)
 * 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/](http://wordpress.org/extend/plugins/wponlinebackup/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Online Backup](https://wordpress.org/support/users/driskell/)
 * (@driskell)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-online-backup-for-wordpress-mysql-problem/#post-2545871)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wponlinebackup_7192a1.svg)
 * [Online Backup for WordPress](https://wordpress.org/plugins/wponlinebackup/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wponlinebackup/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wponlinebackup/)
 * [Active Topics](https://wordpress.org/support/plugin/wponlinebackup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wponlinebackup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wponlinebackup/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Online Backup](https://wordpress.org/support/users/driskell/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-online-backup-for-wordpress-mysql-problem/#post-2545871)
 * Status: resolved