Wordpress Themes - WP Forum at BFA

Wordpress Themes - WP Forum at BFA (http://forum.bytesforall.com/index.php)
-   Atahualpa 3 Wordpress theme (http://forum.bytesforall.com/forumdisplay.php?f=2)
-   -   Remove Post Revisions and optimize database (http://forum.bytesforall.com/showthread.php?t=9768)

Shama Sep 20, 2010 04:18 AM

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.

juggledad Sep 20, 2010 04:43 AM

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.

Shama Sep 20, 2010 11:00 AM

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?

juggledad Sep 20, 2010 11:18 AM

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


All times are GMT -6. The time now is 03:57 AM.

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