Need help on reinstalling my board. Due to lots of plugins and mods installed on my forum some things gone wrong, so now i want to reinstall my board but I'd like to keep posts, threads and users. What SQL tables should I backup to do this? I dont want to keep any code & templates modifications.
Thanks.
mybb_posts mybb_threads and mybb_users should be backed up.
And their additional info ? (Custom) Profilefields?
mybb_attachments
mybb_awaitingactivation
mybb_banned
mybb_favorites
mybb_forumpermissions
mybb_forums
mybb_forumsubscriptions
mybb_groupleaders
mybb_joinrequests
mybb_moderators
mybb_modtools
mybb_mycode
mybb_polls
mybb_pollvotes
mybb_posts
mybb_privatemessages
mybb_profilefields
mybb_reportedposts
mybb_reputation
mybb_sessions
mybb_threadratings
mybb_threads
mybb_threadsread
mybb_userfields
mybb_usergroups
mybb_users
mybb_usertitles
That should keep:
announcements
attachments
users (inc awaiting activation, banned, their reputation, their profile fields, their usertitles, their sessions and their PMs)
user groups (inc leaders and requests)
forums (inc permissions, subscriptions, moderators and mod tools)
custom MyCode
polls (inc votes)
posts (inc reported)
threads (inc ratings and read)
It will not keep:
settings
themes
templates
logs
Obviously if some mods have made changes to those tables, you may have to go through and manually drop any additional columns before your forum will fully work again. Make a full backup beforehand.