Title: Edit post dates – How?
Last modified: August 19, 2016

---

# Edit post dates – How?

 *  [_jc](https://wordpress.org/support/users/_jc/)
 * (@_jc)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/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)

 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181158)
 * > 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](https://wordpress.org/support/users/_jc/)
 * (@_jc)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181220)
 * 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?
 *  [rsciw](https://wordpress.org/support/users/rsciw/)
 * (@rsciw)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181228)
 * In the table wp_posts edit post_date and post_date_gmt.
    Either via phpmyadmin
   or via mysql commandline access.
 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181239)
 * > 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](https://wordpress.org/support/users/_jc/)
 * (@_jc)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181283)
 * 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

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

 * 5 replies
 * 3 participants
 * Last reply from: [_jc](https://wordpress.org/support/users/_jc/)
 * Last activity: [16 years, 9 months ago](https://wordpress.org/support/topic/edit-post-dates-how/#post-1181283)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics