Reduce DB Size

[Michael Molholt]

So, the SQL DB that my forums live on is 6.5GB right now. That's something like 2.7GB+ of forums_posts, 1.8GB+ in core_search_index and some smaller totals in other tables.

I need some ideas on how to reduce the size of this DB, if possible, to under 3GB. Is deletion my only real option? I've tried archiving to an external DB, which has so far moved 1.2GB (this process is painfully slow), but the size of my forum DB hasn't gone down with the archive, it's stayed the same.

Any ideas/help?

[Marc]

The only way in which to remove data from your database, would be to remove data. In other words, indeed delete. The reality is, your database requirements are over that which you are trying to get down to. 3gb is quite a small size to be trying to reduce your database size to. Looking at your license, your site is not a new site, so there is quite a substantial amount of data, and to be honest, 6.5gb isnt very large