Edit post dates – How?

  • 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!

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

  • 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.

    Thread Starter _jc

    (@_jc)

    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?

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

    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.

    Thread Starter _jc

    (@_jc)

    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!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Edit post dates – How?’ is closed to new replies.

Tags