database import problem (trying to restore site)

  • Resolved mium

    (@mium)


    10 years, 11 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

Viewing 2 replies - 1 through 2 (of 2 total)

  • 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).

    Thread Starter mium

    (@mium)

    Thanks for your help. I got it to work!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database import problem (trying to restore site)’ is closed to new replies.