WordPress.org

Ready to get started?Download WordPress

Forums

Edit post dates - How? (6 posts)

  1. _jc
    Member
    Posted 4 years ago #

    I'm manually duplicating an old WordPress blog (2.7.1), because it can't be exported/imported automatically (a long story). It's a rather small blog, so it's not that big a deal to recreate it manually in version 2.8.

    The problem is that I want the old archved posts to be in the same order on the new blog (hopefully with the same old dates) as they used to be on the old blog.

    Is there a plugin or other method of modifying the post dates and post order after I duplicate the archived posts by doing new posts? Or do I have to do the edits to the MySQL database directly. If I have to edit the database (never done so before) will MyPHPAdmin allow me to edit successfully? Won't mess up the tables? Naturally, I'll keep database backups.

    Thanks All!

  2. figaro
    Member
    Posted 4 years ago #

    I'm manually duplicating an old WordPress blog (2.7.1), because it can't be exported/imported automatically (a long story).

    Not sure why that would be true...if you have the db, then it "should" be upgradable and would save you a lot of work.

  3. _jc
    Member
    Posted 4 years ago #

    Like I said "it's a long story". The fact is that it's easier to do it this way - it being a small blog. And I get to leave behind a bunch of custom coding that the previous admin installed that was causing problems and to start fresh. Tried CSV export/import - no good.

    Now back to my question: What's the best way to change post order/dates?

  4. rsciw
    Member
    Posted 4 years ago #

    In the table wp_posts edit post_date and post_date_gmt.
    Either via phpmyadmin or via mysql commandline access.

  5. figaro
    Member
    Posted 4 years ago #

    The fact is that it's easier to do it this way...

    Well, I was going to offer to restore it for you, but if it's easier for you to do it manually, okay...

    Now back to my question: What's the best way to change post order/dates?

    Open each post individually and change the timestamp.

  6. _jc
    Member
    Posted 4 years ago #

    Thanks for your kind offer figaro - much appreciated.
    I didn't realize I had access to the timestamp - will check that out.

    Thanks also rsciw, will use db edit (via phpmyadmin), if I can't edit the timestamp via WordPress 2.8 and my theme.

    Cheers!

Topic Closed

This topic has been closed to new replies.

About this Topic