WordPress.org

Support

Support » How-To and Troubleshooting » SQL Purge of Post Revisions before and after?

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 45MB

    After:
    MySQL Disk Space 76.68 MB
    Actual Backup file size 9.84MB

    That 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";

Viewing 15 replies - 1 through 15 (of 18 total)
Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘SQL Purge of Post Revisions before and after?’ is closed to new replies.
Skip to toolbar