Wordpress Themes - WP Forum at BFA
There will be no more development for Atahualpa (or any other theme), and no support. Also no new registrations. I turned off the donation system. I may turn the forum to read only if it gets abused for spam. Unfortunately I have no time for the forum or the themes. Thanks a lot to the people who helped in all these years, especially Larry and of course: Paul. Take care and stay healthy -- Flynn, Atahualpa developer, Sep 2021

Wordpress Themes - WP Forum at BFA » WordPress Themes » Atahualpa 3 Wordpress theme »

Remove Post Revisions and optimize database


 
Prev Previous Post   Next Post Next
  #1  
Old Sep 20, 2010, 04:18 AM
Shama
 
76 posts · Jun 2010
Remove Post Revisions and optimize database

I read an older post by Juggledad (http://forum.bytesforall.com/showthr...post+revisions) where he mentioned that all post revisions can be deleted by inserting delete FROM `wp_posts` where `post_type` = 'revision' into phpMyAdmin.

I was looking for the phpMyAdmin file and I am not sure if I found the correct file. In wp-admin there is a file called admin.php. Is that the correct file to insert the code? I don't want to screw this one up.

Also Juggledad recommended to optimize the table. How exactly do I do that?

In his original post he recommended the wp-dbmanager plugin. But when I looked it up I noticed that it had last been updated nearly one and a half years ago and is only rated for wp 2.5, so I am not so sure if I want to install that.

So my question is: What is the correct way to get rid of all revision posts (the exact file name where to insert the code), and what is the best way to optimize wordpress and get rid of unneccessary data.

Thanks a lot for all the great support.
 

Bookmarks

Tags
improve wp speed, optimization, optimize database, post revisions, remove post revisions

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Corruption: Visual Editor and Page Revisions vanish when clicking Update! asellon Atahualpa 3 Wordpress theme 33 Nov 23, 2012 02:33 PM
Error with Database igabriela Page & Category Menu Bars 6 Aug 4, 2010 02:49 PM
Database Associate? pdpalmer New Versions, & Updating 2 May 6, 2010 05:29 PM
how to remove Post Title from Single Post page ONLY vargaso Center area post/pages 2 Apr 30, 2010 01:38 PM
Post doesnt pull from database to render in HTML Newdust.com Center area post/pages 3 Feb 22, 2010 05:50 PM


All times are GMT -6. The time now is 08:33 PM.


Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.