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.