Currently I'm having a few problems with my WordPress site:
- a few plugin config pages are not working, I receive the "You do not have sufficient permissions to access this page." error message on them, and it has been happening for some time already and nothing I tried fixed it
- Counterize database is getting HUGE, I think I'll just clean it and restart from scratch on this new year
- I wanna change my wp_ database prefix without worrying with errors I've read about when I was trying to fix first problem
Well, considering all of this, I believe it would be better to do a clean install than trying to do each of those separately. My site has almost 2 years now.
But of course, I don't wanna lose my categories, my tags and aaaaaaall my post and comments in the process. I'm thinking on working to reconfig each and all plugin configs, but that's the maximum I wanna do.
So I'll ask, is there a way to do it? Which tables should I backup and restore and which tables should I let go?
From my 27 tables database, I separated them in this list:
Tables that I will keep:
Tables that I'll delete and let WordPress create new ones:
Tables I don't know what are used for and if I should clean:
And that leaves me with those 2 tables related to users, that I WISH to clean and solve the permission issue but may be required by other tables:
So, does anybody has any idea of how that can be done, and I can have a brand new blog and then restore only the really needed stuff?