Reducing huge mysql database size?

[Xenon]

ups, you have to run also this query then:
[sql]update post set attachmentid=0 where dateline<....[/sql]

you should update your thread counters afterwards so the attachmentcounter is correct again, but nothing more

normally everything should be perfect then, but i can't promise, i've never done that

but your forums and db would work afterwards