WordPress.org

1. KarmaSamten
   Member
   Posted 4 years ago #

   If I want to batch change the timestamp for all of my posts (one category would the best) to be 3 months later, how can I do that? Is there a script or sql file could do that?

2. whooami
   Member
   Posted 4 years ago #

   not that im aware of - you can do it in phpmyadmin though, easily enough.

3. KarmaSamten
   Member
   Posted 4 years ago #

   Do you know how I can do that via phpmyadmin? I know a little of how to use phpmyadmin, but I don't know how to write a proc.
   Thanks

4. whooami
   Member
   Posted 4 years ago #

   you dont indicate what version of wp you are using -- that might make a difference in the query, but heres a start.

   UPDATE 'wp_posts' SET post_date= '2007-08-15 10:30:11', post_date_gmt='2007-08-15 10:30:11'

   change the dates as neccessary, and realize that I havent provided any filtering on the posts -- that will change them all.

5. KarmaSamten
   Member
   Posted 4 years ago #

   Thanks a lot!
   My version is 2.2.
   How can I set a filter? If I want to update the post_date for all the posts under one category, to be 3 months later, how can I achieve that? For example,

   The post_date is 2007-08-15 becomes 2007-10-15
   The post_date is 2007-08-16 becomes 2007-10-16
   The post_date is 2007-08-17 becomes 2007-10-17
   etc.

   Thanks a lot

6. zigx
   Member
   Posted 4 years ago #

   whooami, any update to this? i want to do exactly the same thing.

   thank you very much.

7. whooami
   Member
   Posted 4 years ago #

   why are you doing this? You have a thread - look in it.

8. zigx
   Member
   Posted 4 years ago #

   The reason im doing it is because i have built up a ton of content in my blog but it's just starting to get traffic... so i want to push all the old content forward.

   If you are asking why i posted in this thread its because in my initial thread located here: http://wordpress.org/support/topic/133064 you linked me to this one.

9. whooami
   Member
   Posted 4 years ago #

   why are you doing this means why are you talking in TWO threads. Go read your thread.

10. zigx
    Member
    Posted 4 years ago #

    Could anyone help KarmaSamten and I with this?

    thank you!

11. zigx
    Member
    Posted 4 years ago #

    Is there any information we could add to this thread to make it more clear/relevant?

Topic Closed

This topic has been closed to new replies.