WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] database import problem (trying to restore site) (3 posts)

  1. mium
    Member
    Posted 3 months ago #

    I had a working site on Localhost using Bitnami. I have backups created with the Backwpup plugin. I uninstalled Bitnami and installed WAMP instead. Everything seems fine with 2 new sites I out under WAMP but I am going crazy trying to restore my original backed-up site. I have downloaded a fresh copy of WordPress (3.8.1 just like the original site) in it's own folder under WAMP/www. I copied in the original config file. I go to phpMyAdmin and create a new database (using same name as before which happens to be bitnami_wordpress). I was getting size errors until I increased the upload_max_filesize = 750M in php.ini. Now I get a different error. I would really appreciate any help I get get to figure out this error (Thanks in advance!):

    Error

    SQL query:

    --
    -- Table structure for wp_commentmeta
    --
    DROP TABLE IF EXISTS wp_commentmeta ;

    MySQL said: Documentation
    #1046 - No database selected

  2. davidsword
    Member
    Posted 3 months ago #

    in phpMyAdmin, be sure you're in the database

    bitnami_wordpress

    then hit the import.

    Secondly, in your .sql export, make sure in the first few lines you have

    --
    -- Database: 'bitnami_wordpress'
    --

    if you created the database yourself, you can probably delete the line:

    CREATE DATABASE 'bitnami_wordpress' ...

    (the single quotes in the above are supposed to be backticks).

  3. mium
    Member
    Posted 3 months ago #

    Thanks for your help. I got it to work!

Reply

You must log in to post.

About this Topic