MyBB Community Forums

Full Version: Backup and Restore only Users, Forum, and Thread Post
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,



My Website Has Some Issues, like unable to close the thread and some redirecting issue, i backup sql from PHPMyAdmin and also from ACP right now trying to restor efile with below table

mybb_forumpermissions
mybb_forums
mybb_posts
mybb_threads
mybb_users


but I'm getting some below error


ERROR 1054 (42S22) at line 230: Unknown column 'mobile' in 'field list'



How Can i fix this
Please post your current active plugins list, are you using any mobile theme or mobile related plugin!
I have another question how can I remove all other data except these below tables from phpmyadmin, because my databaae size is 1gb so how can proceed without any issue
mybb_forums
mybb_posts
mybb_threads
mybb_users
most probably posts table could be of huge size & removing contents of other tables might be of little help!
anyway, you can empty the contents of other tables (#)
Here My Table of my website, so tell which should i remove

mybb_adminlog
mybb_adminoptions
mybb_adminsessions
mybb_adminviews
mybb_announcements
mybb_attachments
mybb_attachtypes
mybb_awaitingactivation
mybb_badwords
mybb_bam
mybb_banfilters
mybb_banned
mybb_buddyrequests
mybb_calendarpermissions
mybb_calendars
mybb_captcha
mybb_datacache
mybb_delayedmoderation
mybb_events
mybb_forumpermissions
mybb_forums (This Is Wanted )
mybb_forumsread
mybb_forumsubscriptions
mybb_google_seo
mybb_groupleaders
mybb_helpdocs
mybb_helpsections
mybb_icons
mybb_joinrequests
mybb_mailerrors
mybb_maillogs
mybb_mailqueue
mybb_massemails
mybb_moderatorlog
mybb_moderators
mybb_modtools
mybb_mycode
mybb_mysubs
mybb_mysubscriptions_log
mybb_mysubscriptions_subscriptions
mybb_mysubs_notifs
mybb_mysubs_settings
mybb_parser_cache
mybb_polls
mybb_pollvotes
mybb_posts (This Is Wanted )
mybb_privatemessages
mybb_profilefields
mybb_promotionlogs
mybb_promotions
mybb_questions
mybb_questionsessions
mybb_reportedcontent
mybb_reputation
mybb_searchlog
mybb_sessions
mybb_settinggroups
mybb_settings
mybb_smilies
mybb_spamlog
mybb_spiders
mybb_stats
mybb_tasklog
mybb_tasks
mybb_templategroups
mybb_templates
mybb_templatesets
mybb_themes
mybb_themestylesheets
mybb_threadprefixes
mybb_threadratings
mybb_threads
mybb_threadsread
mybb_threadsubscriptions
mybb_threadviews
mybb_upgrade_data
mybb_userfields
mybb_usergroups
mybb_users (This Is Wanted )
mybb_usertitles
mybb_vipmembership_memberships
mybb_warninglevels
mybb_warnings
mybb_warningtypes
After Empty these tables it's asked i try to upgrade but below error coming

Error
Error
You do not have permissions to run this process. You need administrator permissions to be able to run the upgrade procedure.

If you need to logout, please click here. From there you will be able to log in again under your administrator account.

Error Details

Please Check This Image

http://imgur.com/ZpQ8gfi

Anybody please help me to fix this issue