Title: phpMyAdmin restore wp2_posts how?
Last modified: August 18, 2016

---

# phpMyAdmin restore wp2_posts how?

 *  Resolved [RaymondDay](https://wordpress.org/support/users/raymondday/)
 * (@raymondday)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/phpmyadmin-restore-wp2_posts-how/)
 * Hi. On my WordPress I have over a year on it now. For link photos I had my IP
   in the name. But then I could not get to them on my LAN. But people could out
   side my LAN. So I edit every IP that match mine and just put a .. there. That
   worked so both my in and out side my LAN the photo show up.
 * I have a lot of links. So I went in phpMyadmin and saved the wp2_posts and took
   textpad and found and replace all my IP’s with .. When I went to save it back
   I found out I don’t know how :(. It was easy to delete it. But how do you restore
   it? It was so easy to delete it I thought I could restore it easy too.
 * I got a back up about 2 weeks ago. But I hope I can get this back. I hope some
   one can help. It would of be very hard to edit it all by hand. That’s why I did
   it like this.
 * -Raymond Day

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/phpmyadmin-restore-wp2_posts-how/#post-328435)
 * To restore a table:
 * Open the .sql file in a text editor
    Copy all of it
 * Open phpmyadmin
    Click the sql tab Paste the file you copied into the white box
   Click Go.
 * That should do it.
 * But it is **really important** that you backup your database before doing this!
 *  Thread Starter [RaymondDay](https://wordpress.org/support/users/raymondday/)
 * (@raymondday)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/phpmyadmin-restore-wp2_posts-how/#post-328444)
 * I was messing around with it and I think that is about what I did, what you posted
   podz.
 * I had to delete it first then the next page came up and I clicked on:
 * “Create PHP Code”
 * Then in:
 * “Location of the textfile:”
 * I clicked “Browse” and found the file “wp2_posts.sql” and it said:
 * “Your SQL-query has been executed successfully:
    The content of your file has
   been inserted. (wp2_posts.sql: 595 Instructions)”
 * I am heppy it worked. Thanks for the help!
 * -Raymond Day

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

The topic ‘phpMyAdmin restore wp2_posts how?’ is closed to new replies.

## Tags

 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [RaymondDay](https://wordpress.org/support/users/raymondday/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/phpmyadmin-restore-wp2_posts-how/#post-328444)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics