Restoring database Help

  • I am a bit of a newcomer to wordpress and sql

    I have recently had an issue with my site and have had to delete all files, but have the WP_content file and SQL backup.

    1) I have decided to upgrade to 3.0.1 so I have downloaded fresh install onto domain and install to existing database that has had all tables cleared out(dropped existing tables)

    2) I have then gone into the database and then gone in and “dropped” the default installation tables in the database that were created as result of new wordpress 3.0.1 install

    3) Imported the backup sql from original installation.

    4) When I goto the url the index page does not show, but seems that the wp-admin function works and when I login I see all he data in the admin screen. It just does not show up the web pages to the user.

    5) I have not loaded in the wp-content files as yet as I want to get the database installed correctly first.

    I have also tried to import the original sql backup over the newly created tables from the 3.0.1 but not all tables are created only 18 out of the original 23 and I get an error saying some of the tables exist and cannot be overwritten.

    Am I doing the process correctly and if so why do I not get the index pages to show?

    Sorry but this is all rather new, I have read many of the literature on this but does not seem to answer my scenario

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

  • Try:

    1. Restore your database tables
    2. Upload the WordPress 3.0.1 distribution to your host
    3. Upload your wp-content folder to your host
    4. Fix the wp-config.php to make sure it is using correct database and $table_prefix
    5. Navigate to yourdomain.com/wp-admin/upgrade.php to cause your MySQL tables to be updated to 3.0.1 format.

    Thread Starter condonp

    (@condonp)

    Many Thanks this worked !!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restoring database Help’ is closed to new replies.