We have a forum that has grown over a period of several years and the database is now 1.3 GB. The search_wordmatch table is, of course, the largest at 700 MB. Backups have become a bit of a challenge and we are searching for solutions to either reduce the size of the database or feel confident about an approach to backups that is a little easier than backing up the whole database each time.
So, the question is what would be the actual repercussions of clearing the search_wordmatch table of its data?
Alternatively, but along the same lines, if we were to adopt a backup scheme that bypasses backing up the search_wordmatch table what kind of trouble would we be facing if we had a catastrophic database loss and our backups did NOT contain the search_wordmatch data?