.::Backup DB on Server (Selective Tables) ::.

[Kumaro]

Problem:
The database of my forums is well over 900MB in size after saving it to my server. This is mainly because of my search index which is basically useless to save since it can be rebuilt. In fact, due to this gigantic DB, I can't even backup anymore because the backup script takes so long that it times out.

Solution:
I noticed that it is possible to backup without certain tables of choise, however I need to keep the backups on the server.

I was hoping somebody could make a hack that allows me to backup the database on the server and be able to deselect the tables I don't want to include.

I think this would benefit many sites with large traffic and databases. Thanks