Control how much wordpress post revisions are saved

October 31, 2008

Post revisions is a cool feature, but you probably know that it increase the size of your WordPress database. If you want to limit how many post revisions can be saved by WordPress, or even disabling this functionality. You have to edit your wp-config.php file. The wp-config.php file is WordPress configuration file, where you defined your database parameters when you installed WordPress. It is located on the root of your WordPress install. To limit post revisions, just add the following lines: define ('WP_POST_REVISIONS',... [Read the full story]

Batch deleting wordpress post revisions

October 30, 2008

Post revisions, a WordPress 2.6 new feature can be very usefull, but it also increase the size of your MySQL database. Sure, you can manually delete posts revisions, but that’s a very long and boring work. Another solution is what I’m going to teach you: Batch deleting post revisions. First of it all, login to your phpmyadmin and select your WordPress database. Once done, click on the sql button to open the sql command window. Paste the following sql command in the sql window: DELETE FROM wp_posts WHERE post_type = "revision"; Work’s... [Read the full story]