Restose content from revisions - sql query

Ask Question

Asked 8 years, 11 months ago

Modified 8 years, 11 months ago

Viewed 60 times

How i can restore all posts to the closest revision to a particular date via sql query?

asked Jan 4, 2016 at 22:21

h404

113 bronze badges

1

I would not attempt this in pure SQL.
– s_ha_dum
Commented Jan 4, 2016 at 23:21
I must restore 2000 posts :/
– h404
Commented Jan 4, 2016 at 23:28
1

Still not something for pure SQL. Handle most of the logic in PHP.
– s_ha_dum
Commented Jan 4, 2016 at 23:35
wp_update_post() and wp_get_post_revision()
– Pieter Goosen
Commented Jan 5, 2016 at 5:35

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.