How to add published posts back in after reinstall

  • greatestates

    (@greatestates)


    15 years, 5 months ago

    I had to rebuild my site and now I want to put back the previously published posts. I’ve got a backup I made in phpmyadmin, but have no idea how to do this. Is there an idiot-proof step by step guide somewhere? I can’t find one if there is…

    The only thing I want to retrieve is those posts. Everything else I’ve already re-set up, but I’d like to have the old posts (there aren’t that many) so my history is back on the blog.

    Thanks for any help!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Chris_K

    (@handysolo)

    15 years, 5 months ago

    have a look at this “Importing” section: http://codex.wordpress.org/Test_Driving_WordPress#Importing_Your_SQL_Backup_File

    See if that helps?

    Thread Starter greatestates

    (@greatestates)

    15 years, 4 months ago

    I don’t know what it means about changing the “old” url to the “new” one. The url of my site is the same.

    Here’s my problem. in another post I documented my sudden loss of admin capability. I get a WP Failure Notice every time I try to change anything like settings, themese, manage plugins etc. It won’t let me do anything.

    So I gave up, made a backup, and had my webhost tech people wipe everything out. I reinstalled WP, and tested it, and I had admin control back. Then I put in the theme I want to use, tested, and everything worked. Finally, I wanted to add in my posts & links from my old database. I couldn’t find a way to just pull those out of the db, so I did an import of my old sql using phpmyadmin. And bang, I have all the old problems back.

    So I don’t have admin control any longer, and I want to wipe out everything again, but this time ONLY re-import the posts & links and nothing else. Can anyone help me do this? I really need to get my site back up!! I’m not a techie so I really don’t understand all of this, but hope someone can help.

    Thanks!

    MichaelH

    (@michaelh)

    15 years, 4 months ago

    Then take that .SQL file and make a copy of it. Then using that copy, in a Text Editor, delete everything you don’t want to import. Problem is likely the wp_options table so I’d suggest deleting just that and see if that works.

    Also this assumes your backup is from a Version of WordPress that is the same as the new installation.

    Resources:
    Database Description

    Thread Starter greatestates

    (@greatestates)

    15 years, 4 months ago

    How do I open this file to edit it? It’s in some kind of zip form, .gz, and I can’t get anything to extract it.

    ktomasch

    (@ktomasch)

    15 years, 4 months ago

    Okay, this is strange. I did the reinstall. It’s obviously linking to the database because my posts are coming up. But it’s not in the format that it was in before and it won’t let me login. Strange. I can’t get it back to the way it looked before, but the posts are there.

    All the links go to /blog/filename_whatever and not to the new directory /the_blog/ where I’ve put all the new files. Hmmmmm.

    ktomasch

    (@ktomasch)

    15 years, 4 months ago

    And then when I go to the install.php file, I get this:

    Already Installed
    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

    I don’t recall that being in the several-step-progress to reinstall. I DID back up the database, but do I then have to clear that out by killing it all out of my SQL thing and then re-doing it?

    :confused:

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to add published posts back in after reinstall’ is closed to new replies.