Forums

Install with SQL dump (9 posts)

  1. Enron
    Member
    Posted 4 years ago #

    I have a sql dump from a crashed site with wordpress 2.0.5 and are about to set it up at another ISP. How should I do this:

    - install latest wp and import the dump?
    - install 2.0.5, import dump and then upgrade? Upgrade straight to 2.3.3 or in steps?

    Also gratefull for anything else to consider using sql dump from other ISP.
    Thanks /E

  2. MichaelH
    Volunteer
    Posted 4 years ago #

    1. If you haven't, create the MySQL database
    2. Use phpMyAdmin and import the sql dump.
    3. Upload 2.3.3 files and configure wp-config.php accordingly
    4. Upload 2.3.3 ready theme/plugins
    5. Browse to wp-admin/upgrade.php to 'execute' the upgrade.**
    6. Update your permalink structure

    **www.sample.com/wp-admin/upgrade.php or http://www.sample.com/wordpresssubfolder/wp-admin/upgrade.php (depends on where you put the wordpress files)

  3. ShaneH
    Member
    Posted 3 years ago #

    I've recently had to go through this same process.

    I took a back up SQL dump, imported it, moved over all the original WordPress files, upgraded etc...

    The original version was 2.2.2 and hosted with Yahoo.

    My problem is that I don't see any posts or archives from the old dump. They're in the database, but WordPress isn't displaying them.

    I've tried changing multiple settings in the WordPress admin, but no luck.

    Any suggestions?

  4. ShaneH
    Member
    Posted 3 years ago #

    FYI: wp-config.php is configured correctly.

    I see recent comments, but nothing else.

    Doing a search will bring up posts, but can't click through to see them.

    Permalinks settings are correct.

  5. MichaelH
    Volunteer
    Posted 3 years ago #

    Have you tried deactivating ALL plugins and changing to the WordPress Default 1.6 theme?

  6. ShaneH
    Member
    Posted 3 years ago #

    Yup - a few times - no difference.

    Here it is now:

    http://studentpr.sangsara.ca/

  7. MichaelH
    Volunteer
    Posted 3 years ago #

    That's not the WordPress 1.6 Default theme.

  8. ShaneH
    Member
    Posted 3 years ago #

    I know. The default theme doesn't make a difference. Same results.

  9. MichaelH
    Volunteer
    Posted 3 years ago #

    Then I'd be tempted to do the database restore again and then do the update.php process (should happen automatically upon login).

    You'll need to DROP the existing tables before doing the import.

Topic Closed

This topic has been closed to new replies.

About this Topic