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

  1. mium
    Posted 1 year 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!):


    SQL query:

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

    MySQL said: Documentation
    #1046 - No database selected

  2. davidsword
    Posted 1 year ago #

    in phpMyAdmin, be sure you're in the database


    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
    Posted 1 year ago #

    Thanks for your help. I got it to work!

Topic Closed

This topic has been closed to new replies.

About this Topic