Ever since I moved my blog to another host (Dreamhost) last summer, I've been having strange little issues that I've posted about before, but found no real answers. Things like always getting a "Saving post . . ." message in the edit screen (the post does get auto-saved, but the message gets stuck), unable to get to some plugin settings screens (insufficient permissions), and -- this is new -- inability to upgrade WP automatically. And a few other things, none of which are, on their own, catastrophic, but together are a pain.
To try to solve this, I've tried turning off and deleting all plugins, refreshing all the WP files, switching to the default theme, etc. After doing some research, I really think it's the database that's to blame. I thought it had something to do with prefixes, but they all seem to be fine (although I once used a security plugin on the install at the old host that I think did something with prefixes, but like I said, all of them seem to properly have the wp_ prefix).
So now, I think it's time to just go with a fresh database. Can anyone point me to some step-by-step instructions on how to do this without resorting to a completely fresh install?