Many people may have been grappling with a feature in WordPress which makes it save several post revisions every time the writer updates a post.
WordPress is a great piece of web-based software for bloggers and online publishers in general.
Why WordPress Post Revisions?
This is a feature built into WordPress by default that allows the writer to automatically leave a paper trail of back-ups for each post.
These revisions are actually full posts created every time the update button is pressed in the post editor. The reason for this is that it allows the publisher to roll back any article to any previous version.
These WordPress post revisions do not necessarily affect the experience of the website visitors so generally if you do not need them there is no reason to keep them around.
The main problem with the post revisions is that they can really make your WordPress post table grow to really large size.
Let’s say you have thousands of articles running on WordPress, depending on how you edit your articles you can have an average of two to three revisions per post and that can triple, quadruple the size or more of your WordPress MySQL database post table.
To keep your table clean and lean there is a way to disable WordPress post revisions.
All you need to do is:
- Ask your developer to access the WordPress installation via several methods including ssh, SFTP is known as SSH File Transfer Protocol, also Secure File Transfer Protocol is the replacement for the non-secure legacy FTP (File Transfer Protocol). It is an extension of the Secure Shell protocol that is used as a network protocol that provides file access, file transfer, and file management over any reliable data stream. SFTP supports the full security and... More, FTP, CPanel file manager or whichever method your hosting A server is a computer application program that responds to requests for information from a client in a client/server relationship system. A typical example is a web server or pushing a web page to a web browser or a web server receiving email and transferring it to an email client. A server can also refer to the actual hardware designed... More supports.
- With a text editor open the file wp-config.php which can be found in the root A folder or directory is an organized collection or group of files on a computer system that can be accessed from a filesystem path. The Folder is the term usually used on Windows-based systems while the directory is the term used on other major operating systems such as Unix, Linux, OSX, iOS, and Android. In Unix based systems, a directory... More of the installation.
- Insert the following line somewhere in the file. Preferably after other configuration directives.
define(‘WP_POST_REVISIONS’, false );
That’s it. Your WordPress installation will no longer create the multiple post revisions every time you make a post update.
To get rid of previous WordPress post revisions you will have to go in an remove them manually from within a MySQL A client is a computer application program that requests information from a server in a client/server relationship. A typical example is a web browser accessing a web page from a server.... More or preferably using a plugin. Bulk Delete is a great plugin to manage and clean your posts table.