reinstall from database backup

  • Resolved nunomira

    (@nunomira)


    17 years, 1 month ago

    Hi,

    I have the database backup from a 2.0.4 installation.

    I’m trying to install it locally.

    I’ve rebuilt the database and downloaded 2.0.9. I’ve placed the files in the correct folder and edited wp-config.php correctly.

    But when I go to http://localhost/wordpress/ I get the message:

    It doesn’t look like you’ve installed WP yet. Try running install.php.

    I’ve also tried the update install but I got 3 errors and it didn’t work.

    I tried the same with 2.0.4 but no luck.

    How can I do this? Would I need the existing files and folders?
    Isn’t it possible to restore the database using a clean install?

    I searched a lot but couldn’t find anything definitive.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Samuel B

    (@samboll)

    17 years, 1 month ago

    You should be able to do it with a clean install, then drop all tables in db and import db and run the upgrade script.
    The reason you’re getting the error message is because the db is already populated.

    If you still have your previous install set up, you might try doing it with the xml file with this plugin.
    http://technosailor.com/wordpress-to-wordpress-import/

    Thread Starter nunomira

    (@nunomira)

    17 years, 1 month ago

    hi,

    Thank you for that suggestion. I hadn’t thought about that.

    So I tried it:
    – clean 2.0.9 install
    – drop all the tables
    – inserted all the content
    – run upgrade script

    I get exactly the same error:

    WordPress database error: [Table ‘wordpress.wp_options’ doesn’t exist]
    SELECT option_value FROM wp_options WHERE option_name = ‘db_version’

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    Warning: Invalid argument supplied for foreach() in C:\wamp\www\wordpress\wp-admin\upgrade-functions.php on line 298
    Step 1

    There’s actually only one step. So if you see this, you’re done. Have fun!

    The two errors are strange…
    All the tables have the prefix blog_, so there isn’t a wp_options.
    And there isn’t a column user_nickname in blog_users. There’s just a user_nicename.

    Thread Starter nunomira

    (@nunomira)

    17 years, 1 month ago

    Sorry.
    What I wrote above rang a bell. It was the tables’ prefix after all.
    I hadn’t edited the wp-config.php correctly after all.

    When I did it, these steps worked just fine:
    – built folder structure with the 2.0.9 files
    – populated database
    – in the table blog_options I edited the siteurl

    When I went to the wp-admin/ , I was prompted to run the upgrade script which I did with no more errors.

    Everything seems to be fine now!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘reinstall from database backup’ is closed to new replies.