My databases have been giving me problems for quite sometime, and now it's become crucial to fix.
I have corrupt tables that keep on crashing my server.
I've been told that the schema is old and the original old wp database was used for an wpmu install.
Anyway, many things wrong and a few people from here have had a look at it.
Those that have tried to fix it have only done so temporarily and no one else is very keen to jump in and dissect it.
Want to know what my options are:
I have multi db with 16 db's, is there a way that I can manually combine all the tables into a new db?
If so, how would I go about that?
Would that fix the corrupt tables?
What if I want to rescale to 256 db's?
I'm thinking a clean slate with new db's are the way to go, but don't want to lose any data.
What's the best thing to do with the least amount of effort that will be more attractive for programmers to take this on and fix it?