Is there a way of resetting the mySQL db to all defaults? Maybe code I can cut and paste?
I've found how the spammers were getting in without registering however the best security precaution is to reset all to default, just in case I miss something.
I'm still stuck on this - My forums have been suspended for well over a year now because the tables simply do not communicate with each other. There is nothing else wrong with the site. Any help would be appreciated.
You mean the fusion settings which are set on setup process? There is no easy way to reset them, you need to take the setup.php and have a look at the settings you want to restore by hand.
You cannot reset a database table, you can only dump all data (empty all tables). The default for any database is having no (0, zero) tables with no data, which means you have to run the fusion setup again.