Title: Install with SQL dump
Last modified: August 19, 2016

---

# Install with SQL dump

 *  [Enron](https://wordpress.org/support/users/enron/)
 * (@enron)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/install-with-sql-dump/)
 * 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

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

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697721)
 * 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](http://www.sample.com/wordpresssubfolder/wp-admin/upgrade.php)(
   depends on where you put the wordpress files)
 *  [shaneh](https://wordpress.org/support/users/shaneh/)
 * (@shaneh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697953)
 * 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?
 *  [shaneh](https://wordpress.org/support/users/shaneh/)
 * (@shaneh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697954)
 * 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.
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697955)
 * Have you tried deactivating ALL plugins and changing to the WordPress Default
   1.6 theme?
 *  [shaneh](https://wordpress.org/support/users/shaneh/)
 * (@shaneh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697956)
 * Yup – a few times – no difference.
 * Here it is now:
 * [http://studentpr.sangsara.ca/](http://studentpr.sangsara.ca/)
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697958)
 * That’s not the WordPress 1.6 Default theme.
 *  [shaneh](https://wordpress.org/support/users/shaneh/)
 * (@shaneh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697959)
 * I know. The default theme doesn’t make a difference. Same results.
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697960)
 * 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.

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

The topic ‘Install with SQL dump’ is closed to new replies.

## Tags

 * [dump](https://wordpress.org/support/topic-tag/dump/)
 * [reinstall](https://wordpress.org/support/topic-tag/reinstall/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 8 replies
 * 3 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/install-with-sql-dump/#post-697960)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics