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


  #1  
Old Sep 20, 2010, 04:18 AM
Shama
 
76 posts · Jun 2010
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.
  #2  
Old Sep 20, 2010, 04:43 AM
juggledad's Avatar
juggledad
 
23,765 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
phpMyAdmin is NOT part of WordPress. It is a separate application that many host have installed to allow you to manage your databases. You will need to look at the applications that your host provides to see if they have it installed.
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
  #3  
Old Sep 20, 2010, 11:00 AM
Shama
 
76 posts · Jun 2010
Thanks for the info. I found the phpMyAdmin application, I used your code, and it worked like a charm. Tons of revision lines are gone. I also used your code to limit revisions to two only, great!

Since you had mentioned in your original post that it is advisable to optimize the databases, what is the best way to do that?

Is it advisable to try to run the wp-dbmanager plugin which has not been updated since wp 2.5, or is there another way to optimize?
  #4  
Old Sep 20, 2010, 11:18 AM
juggledad's Avatar
juggledad
 
23,765 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
I use the wp-dbmanager plugin all the time, however you can also optimize the tables via phpMyAdmin.

Some Hosts change the parts of phpMyAdmin you can use, but if you select your database and see all the tables with the check boxes next to them, there should be an action selector and one of the options should be OPTIMIZE TABLE option you can use
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/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:35 PM.


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