Basically, I wanna keep the basics, ie. Users and Threads while deleting all settings I may have changed; since I keep getting database errors and would like to start again.
Disable your hooks (plugins) and see if you still have the database errors. Your situation may not be as bad as you think. Always try new coding, (modifications) out on a local development system.
Fixing the database in most cases is not that difficult: as long as your attachments are still connected to the posts etc...