To delete revision here is their solution:
# DELETE a,b,c
# FROM wp_posts a
# LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
# LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
# WHERE a.post_type = ‘revision’
I wonder if something is wrong with this request:
DELETE FROM wp_posts WHERE post_type = “revision”;
What is stored in postmeta?
- The topic ‘Delete revision’ is closed to new replies.