Supprimer les versions sauvegardées

5 février 2015

Pour supprimer toutes les versions, saisir cette requête en base de donnée :

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';

Pour supprimer les versions antérieurs à une date précise :

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'
AND a.post_date < '2010-01-01';

Join Our Mailing List

Once Weekly Webinar

Free Webinar Once Per Week

Our free webinar runs once per week and is available to anybody who wants to know more about getting started on the road to financial freedom.

Aller en haut