SQL Purge of Post Revisions before and after?
-
I noticed the crazy amount of post revisions for every post i had so i did some searching and purge unused revisions from my database.
The questions is does this sound right about the SQL size now?
Before:
MySQL Disk Space 76.68 MB
Actual Backup file size 45MBAfter:
MySQL Disk Space 76.68 MB
Actual Backup file size 9.84MBThat is a huge drop in size I am showing no errors anywhere the purge was successful over 600 post checked older ones still valid data.
The purge code was
DELETE FROM wp_posts WHERE post_type = "revision";
- The topic ‘SQL Purge of Post Revisions before and after?’ is closed to new replies.