Title: Help with importing .sql file
Last modified: August 31, 2016

---

# Help with importing .sql file

 *  [mariafgp](https://wordpress.org/support/users/mariafgp/)
 * (@mariafgp)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/help-with-importing-sql-file/)
 * I have an old backup .sql file from a version 3.4.1 WordPress installation. Had
   to reinstall WordPress using 4.4.2. Not sure what version the old MYSQL was using.
   Got this from the .sql file:
    — Server version: 5.0.92 — PHP Version: 5.3.4
 * Currently using version 5.5 of MYSQL and PHP Version: 5.4
 * Is there any way that I can use the backup .sql file so that I can see the posts
   that were entered and maybe import them into the current installation of WordPress?
   I don’t mind copy and pasting as long as I can see the posts.
 * I have tried installing the old code and then overwriting the database but that
   just gives me a blank screen.

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

 *  [Lalit Nagrath](https://wordpress.org/support/users/laliz/)
 * (@laliz)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/help-with-importing-sql-file/#post-7047914)
 * > I have tried installing the old code and then overwriting the database but 
   > that just gives me a blank screen.
 * was this on home page of website or in wp-admin screen was white too?
 * if you can access wp-admin after importing, go to posts and check if old posts
   are there. white page on front page can be due to theme, go to themes and reselct
   a theme.
 * to import .sql files you should use mysql or phpmyadmin.
    [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup)
 *  Thread Starter [mariafgp](https://wordpress.org/support/users/mariafgp/)
 * (@mariafgp)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/help-with-importing-sql-file/#post-7047920)
 * I tried everything suggested. It didn’t work. I think since the .sql file is 
   so old there may not be anything in there worth saving. I gave a brand new up
   to date WordPress blog. She will have to start posting from scratch.
 *  [yenuel](https://wordpress.org/support/users/yenuel/)
 * (@yenuel)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/help-with-importing-sql-file/#post-7048201)
 * I am kind of new here and this post is a month old. So i don’t know the site’s
   rule about that. But for others who might find this post in the future.. .
    I
   encountered the exact same problem today. Where importing will be successful,
   but the website just disappears, With no error code white page and no title. 
   as it turns out the problem is with the wp_options table. So if you want to recover
   your posts, pages, links, menus and just all of your data except for your general
   settings such as site title and theme options, such as where your menus appear
   And how your website looks, make a copy of your sql file and open it in a notepad
   ++ or other text editor and delete wp_options, all of it. I am currently looking
   at the wp_options code to find the exact problem so you may recover the wp_options
   table too so keep the original sql … But you can use this method to import your
   other data.
 * Cheers

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

The topic ‘Help with importing .sql file’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [yenuel](https://wordpress.org/support/users/yenuel/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/help-with-importing-sql-file/#post-7048201)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics