Delete Post revisions
So you have those crazy post revisions listed on your blog under your post development page. 
You also know for a fact that you don’t need to keep them and are happy with your current revision.
So what you need to do is to go to your phpMyAdmin 
page and do the following.
Type the following into the SQL command line interface:
NOTE: This only works if you have already published your page. (e.g. not saved draft)
After that you should have empty post revisions and therefore the backups for your website should not take as long to accomplish.
loading...
loading...
About the author
I have a Bachelors Degree in Physical Sciences from University of Maryland and am currently pursuing a Masters in Software Engineering. My passion is software programming; (PHP (Some OOP), MySQL, jQuery, JavaScript, HTML, CSS, XHTML, AJAX, C, Some C#, Learning Drupal, Visual Basic, and some JAVA), and I continue to work on perfecting my skills. I am interested in anything technology related. I am in the process of starting my own business WordPress Xtensions which mainly revolves around WordPress Plugins, Themes and general website help.
| Print article | This entry was posted by Tom on April 3, 2009 at 1:56 pm, and is filed under Computer Programming. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No comments yet.
No trackbacks yet.
WPXtensions.com is finally here!
about 9 months ago - 1 comment
OK so the business website is finally up and running. Check it out!!!!! https://wpxtensions.com
Plugins Updates With SVN Repos and WebSVN
about 11 months ago - 2 comments
I have been creating and configuring all sorts of new applications and wanted a way to track and update my plugins and projects easily and conveniently, so I created Plugin Updates plugin. This plugin makes a breeze to configure and update all things related to plugins. I first installed SVN and WebSVN on my server…
My Command Center
about 1 year ago - 1 comment
Ok so I wanted to write and tell you all what I have been up to. I have been very busy after graduation from college. In the process of starting my own business for WordPress Extensions (Wpxtensions.com). My first project and one of my favorites is my server that is installed at my house (running…
Two New Plugins added
about 1 year ago - 2 comments
I have added to new plugins that I have made and developed: Flow Player Plugin For WordPress and Slider Plugin For WordPress I made these two plugins for ease of use of my website and the more plugins, the better the website lol!!!!!!
Arras theme page comments
about 2 years ago - 1 comment
Ok so I ran into this while looking at my site after upgrading to wordpress version 2.9 and found that all my comments for pages disappeared but the post comments were fine, So I googled and found that arras theme has a conflict with wordpress v2.9. and this is the issue and wamo-bamo it worked!
Top 20 WordPress Plugins I’m featured #11
about 2 years ago - 7 comments
Thanks to Kerry Webster for the table and the download link to the pdf download!
I’m featured in a Magazine!
In issue 164 of Web Designer Magazine there is a feature article on WordPress plug-ins, “Electrify Your Blog: The Top 20 WordPress Plug-ins for the Next-gen Blogger”. Matt Mullenweg
My own RSS for music files from PHP
about 2 years ago - No comments
If you have read the previous post about the Website Music Player than you should be able to understand a little more about what is said in this post.
I was searching for hours and hours the other day and found some snippets of code to generate my music RSS and wow I love IT! I used PHP and xml to generate the RSS format.
I first had thought about how I generated the .xml code from the media player list and then found some things that could help in order to generate the correct information for the RSS feed.
So here is the code that I made that works: (put this code in a music_rss.php file)
Website Music Player
about 2 years ago - 9 comments
I am finally able to sit down and tell you about the media player that I put on my website. As you can see to the right is a music player and the code that I used is valid XHTML. So here we go:
Javascript Confirmation and variations
about 2 years ago - No comments
I wanted to make a pseudo login scheme for my page and came across some really cool stuff so take a look….
wp_get_archives(‘type=alpha’)
about 2 years ago - 2 comments
Thanks to great find I was able to make some sweet adjustments to my site. With some modification to what JTK said on his website I used some really cool drop down boxes to achieve what I wanted on my site. I will give you the code for both…
