Scrap your post revision with SQL shredder!
Version: 15.1
Revision: 45 Build 13
Scrap your post revision with SQL shredder!
Introduction: On Halloween day, I was bored as hell! I am too old for these “Trick ‘N’ Treat” sort of things.
But, I did have a good time writing my own article and give the other children and the others candies, chocolate and sweets. So, what about my readers? Don’t worry! Here is a mini – tutorial for you to learn and enjoy.
This tutorial is about controlling your “WP – post revision” with a little help from “phpMyAdmin – Query and by editing your wp-config.php file.” However, please be careful when you’re modifying your “wp-config.php” file.
Notes: The “config” file is the hearth of your WordPress database. So, in my own judgment, just make a backup of your “wp-config.php” file.
It’s not that hard – for crying out loud…
1.] Login to your Cpanel and navigate to your blog’s directory. After that, you’ll need to edit your ‘wp-config.php’ file and add these lines into the top of your file.
define ('WP_POST_REVISIONS', 6); //Defines a maximum of 6 different revisions per post.
define ('AUTOSAVE_INTERVAL', 3600); // Auto-saves on 1 hour interval.
2.] Save your changes and exit your ‘config’ file.
3.] In your Cpanel directory [Home], please scroll down and look for “phpMyAdmin” and select it.
4.] Wait for the control panel to load its settings and click on your “SQL” icon.
Facts: this icon is called: SQL query command. It is located on the top – left – corner, which is next to a little house icon (Home).
5.] Copy this code and paste the following code into the “SQL command” window.
DELETE FROM wp_posts WHERE post_type = "revision";
6.] Execute the script and let it erase all of your previous “post – revision”.
7.] You’re Done!
Alternative for “WP – AUTOSAVE_INTERVAL”.
- There is another way to change your “WordPress autosave interval.”
But, you’ll need to look for this file: “wp-settings.php” and edit these parts which is shown below.
Notes: The actual lines is around 522 – 528. Just scroll down or search for the lines with this phrase: “AUTOSAVE_INTERVAL.”
/** * It is possible to define this in wp-config.php * @since 2.5.0 */ if ( !defined( 'AUTOSAVE_INTERVAL' ) ) define( 'AUTOSAVE_INTERVAL', 60 );
— Times —
60 sec = 1 minutes
1800 sec = 30 minutes
1980 sec = 33 minutes
3000 sec = 50 minutes
3600 sec = 60 minutes
Copyrighted By Lair360
