Here are a few tables that tend to bloat your Magento database. As always, before running any script: MAKE A BACKUP
If you want to save the data, it is easy enough to dump your database and extract the following tables. Over time there tables will grow quite large so it is a good idea to keep them clean!
Please comment on any other tables you find useful!
Wait! did I mention ALWAYS MAKE A BACKUP ?