Title: Restoring SQL Databse – Problems = Blank page.
Last modified: August 19, 2016

---

# Restoring SQL Databse – Problems = Blank page.

 *  [jackbrennan2008](https://wordpress.org/support/users/jackbrennan2008/)
 * (@jackbrennan2008)
 * [16 years ago](https://wordpress.org/support/topic/restoring-sql-databse-problems-blank-page/)
 * Hi there,
 * _I am using WordPress 2.9.2 on my live site, and i am trying to import my live
   site locally to the new WordPress 3.0RC1_
 * I have decided to use wordpress locally for any major changes i might be doing
   to my website. Unfortunatly i have come across a problem!
 * I have backed up my wordpress database via phpmyadmin and used the export feature
   in the wordpress control panel to backup my wordpress site.
 * The problem is this:
 * 1. I installed XAMPP and got the server running locally
    2. I copied all the 
   wordpress 3.0 RC1 files to the httdocs directory. 3. I then created a database
   in phpmyadmin with the same name as my database which is currently online. 4.
   Then i ran the wordpress install and gave wordpress the name of the new sql database
   and i just used the default sql user and password supplied by XAMPP root and 
   no password. 5. I imported the wordpress site using the import plugin in the 
   wordpress control panel 6. I go into 127.0.0.1 and my website is there and all
   my posts are back, but there are no comments and such!
 * **So far so good!**
    ** 6. Now i go into Phpmyadmin and import the exported database
   which works as it should. 7. I then go to 127.0.0.1 to see if it has been restored
   successfully, but its not. I am greeted with a blank page.
 * There is something going wrong when i import the database, do i need to use the
   same sql password that i am using on my live site? Why does importing my sql 
   database break my wordpress install?
 * I hope i have been as clear as possible and any help would be appreciated.
 * Jack.

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

 *  [ambergris75](https://wordpress.org/support/users/ambergris75/)
 * (@ambergris75)
 * [16 years ago](https://wordpress.org/support/topic/restoring-sql-databse-problems-blank-page/#post-1522426)
 * …just wondering, were you using a different database table prefix other than “
   wp_” in your old table? Did you remember to change it in the new database?
 * Some links that might help:
    [http://yoast.com/move-wordpress-blog-domain-10-steps/](http://yoast.com/move-wordpress-blog-domain-10-steps/)
 * [http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress](http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress)
 * Hopefully others will come along who can help you a bit more.
 *  Thread Starter [jackbrennan2008](https://wordpress.org/support/users/jackbrennan2008/)
 * (@jackbrennan2008)
 * [16 years ago](https://wordpress.org/support/topic/restoring-sql-databse-problems-blank-page/#post-1522427)
 * Yea i changed the prefix so they are both the same: I’ll have a look at those
   link and see how i go 🙂

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

The topic ‘Restoring SQL Databse – Problems = Blank page.’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [jackbrennan2008](https://wordpress.org/support/users/jackbrennan2008/)
 * Last activity: [16 years ago](https://wordpress.org/support/topic/restoring-sql-databse-problems-blank-page/#post-1522427)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics