Title: After sql import
Last modified: August 19, 2016

---

# After sql import

 *  Resolved [bubbles00](https://wordpress.org/support/users/bubbles00/)
 * (@bubbles00)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/after-sql-import/)
 * Hi everyone.
 * My old blog was some how messed up so bad I could no longer login so I made a
   new wordpress blog. Luckily I had an sql backup saved of the old blog. I was 
   very scared not to mess the new blog so I actually installed one more wordpress
   just to test (!)
 * On my testing blog I followed the sql restore tutorial ([http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup))
   and gathered the courage to import sql. After a while I got the success message
   saying that my import was sucessful.
 * However, I don’t see any of my old posts/categories etc on the blog or dashboard.
 * I checked the sql again I saw that there are duplicate tables of everything, 
   one with the prefix mywp and other with wp. I must have named the table prefix
   mywp on my old blog…now how do I change this… I mean is there a way to get my
   old posts on my new testing blog?? 🙁
 * Please help me!
 * P.S: I am an absolute N00b and I dunno anything about sql stuff so forgive me
   if I make no sense…

Viewing 1 replies (of 1 total)

 *  Thread Starter [bubbles00](https://wordpress.org/support/users/bubbles00/)
 * (@bubbles00)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/after-sql-import/#post-1186336)
 * meh, I am sorry to say this but no one ever replies to my posts on this forum
   when I need help…I found the fix myself.
 * Anyone having the same problem should follow this at their own risk:
 * The problem I had was that my old blog (the backup sql of which I had) had the
   table prefix mywp. My new blog had the table prefix wp. So After following the
   aforementioned tutorial of importing sql through phpadmin, my posts/pages/categories/
   comments were not updated even though the sql data was added to the new one because
   of different table prefixes.
 * **What I did was: **First of all, I did all this to a new TESTING blog, so that
   even if anything went wrong, I wont mess up my site/new blog.
    ** The fix:
 * 1.) Save an original backup file copy….always!
 * 2.) Open the backup sql file in text editor like word pad (I used Notepad++).
 * 3.) Search for the old table prefix (mine was mywp).
 * 4.) Replace the old prefix name text with the new table prefix on your current
   testing blog (its usually wp if not changed in config.php file).
 * 5.) Replace the mywp with wp in the whole file.
 * 6.) Save the sql file.
 * 7.) Follow the [ sql restore tutorial](http://codex.wordpress.org/Restoring_Your_Database_From_Backup)
   and backup the sql using the new saved file.
 * 8.) Cross fingers and hopefully you will receive a success message after a while.
 * 9.) Go to your new testing blog and you will see it working.
 * 10.) If you see a blank page try changing your theme to default one/classic.
 * **IMPORTANT!:** I am not an expert and I found this cure myself and it worked
   for me. Please follow this at your own risk and always store backups of backups
   and everything else. I tested this in a test blog first, you can do the same 
   to be safe.
    Good luck.

Viewing 1 replies (of 1 total)

The topic ‘After sql import’ is closed to new replies.

## Tags

 * [after](https://wordpress.org/support/topic-tag/after/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [prefix](https://wordpress.org/support/topic-tag/prefix/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [bubbles00](https://wordpress.org/support/users/bubbles00/)
 * Last activity: [16 years, 9 months ago](https://wordpress.org/support/topic/after-sql-import/#post-1186336)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics