Support » Fixing WordPress » phpMyAdmin restore wp2_posts how?

  • Resolved RaymondDay


    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)


    Support Maven

    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 !

    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.