how to optemize the database to make it smaller

[stinger2]

a general question

with time the database is growing too much which makes the maintenance and moving the site more difficult
so my question is
can we remove some unnecessary componants from it

like deleting all the PM and Pm text
deleting all log files
any other non essential parts ....to be rebuild again

just to make it more clear

for example
deleting PM as running this query
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext
(answered in anoither thread)

i dont know though wether I should run these queries apart or as one

i mean
TRUNCATE TABLE pm

and hit run

then another query
TRUNCATE TABLE pmtext

or i paste both of them and excute as one as??

[stinger2]

PHP Code:

UPDATE `user` SET `pmtotal` = '0',`pmunread` = '0'; 
TRUNCATE TABLE `pm`; 
TRUNCATE TABLE `pmtext`; 
TRUNCATE TABLE `pmreceipt`; 


queries are run one query at a time

got this answer from vbulletin.com just in case any one is also interested in this subject

credits to Steve Machol