XF 1.2 Clean up database after import

[zastavra]

I've switched from vb to xf and I'd like to ask if xenforo uses all these tables in the database? I mean, do I need now all these "for_" tables that came from vbulletin?

 

[Paul B]

XenForo doesn't import nor create any tables from vBulletin during an import.

All it does is populate the XenForo tables with the data from the vBulletin database.

All of the XenForo tables are prefixed xf_.

 

[zastavra]

So, I guess I can safely drop all for_blahbla tables, right?

 

[Paul B]

Are the tables in the same database?
You should have created a new, separate database for your new XenForo installation and imported into that.

 

[zastavra]

This is a new database than I created for the xf installation. I have no idea how all these tables found there.

 

[Paul B]

Can you post the full list of tables in code tags?
I just want to see exactly what tables are in the database.

 

[zastavra]

Sure...

archived_import_log
for_access
for_action
for_activitystream
for_activitystreamtype
for_ad
for_adcriteria
for_adminhelp
for_administrator
for_adminlog
for_adminmessage
for_adminutil
for_album
for_albumupdate
for_announcement
for_announcementread
for_apiclient
for_apilog
for_apipost
for_attachment
for_attachmentcategory
for_attachmentcategoryuser
for_attachmentpermission
for_attachmenttype
for_attachmentviews
for_autosave
for_avatar
for_bbcode
for_bbcode_video
for_block
for_blockconfig
for_blocktype
for_blog_sitemapconf
for_bookmarksite
for_cache
for_cacheevent
for_calendar
for_calendarcustomfield
for_calendarmoderator
for_calendarpermission
for_cms_article
for_cms_category
for_cms_grid
for_cms_layout
for_cms_layoutwidget
for_cms_navigation
for_cms_node
for_cms_nodecategory
for_cms_nodeconfig
for_cms_nodeinfo
for_cms_permissions
for_cms_rate
for_cms_sectionorder
for_cms_widget
for_cms_widgetconfig
for_cms_widgettype
for_contentpriority
for_contentread
for_contenttype
for_cpsession
for_cron
for_cronlog
for_customavatar
for_customprofile
for_customprofilepic
for_datastore
for_dbquery
for_deletionlog
for_discussion
for_discussionread
for_editlog
for_event
for_externalcache
for_faq
for_filedata
for_forum
for_forumpermission
for_forumprefixset
for_forumread
for_groupmessage
for_groupmessage_hash
for_groupread
for_holiday
for_humanverify
for_hvanswer
for_hvquestion
for_icon
for_imagecategory
for_imagecategorypermission
for_indexqueue
for_infraction
for_infractionban
for_infractiongroup
for_infractionlevel
for_ipdata
for_language
for_linkback
for_mailqueue
for_moderation
for_moderator
for_moderatorlog
for_navigation
for_notice
for_noticecriteria
for_noticedismissed
for_package
for_passwordhistory
for_paymentapi
for_paymentinfo
for_paymenttransaction
for_phrase
for_phrasetype
for_picturecomment
for_picturecomment_hash
for_picturelegacy
for_plugin
for_pm
for_pmreceipt
for_pmtext
for_pmthrottle
for_podcast
for_podcastitem
for_poll
for_pollvote
for_post
for_postedithistory
for_posthash
for_postindex
for_postlog
for_postparsed
for_prefix
for_prefixpermission
for_prefixset
for_product
for_productcode
for_productdependency
for_profileblockprivacy
for_profilefield
for_profilefieldcategory
for_profilevisitor
for_ranks
for_reminder
for_reputation
for_reputationlevel
for_route
for_rssfeed
for_rsslog
for_rules
for_searchcore
for_searchcore_text
for_searchgroup
for_searchgroup_text
for_searchlog
for_session
for_setting
for_settinggroup
for_sigparsed
for_sigpic
for_smilie
for_socialgroup
for_socialgroupcategory
for_socialgroupicon
for_socialgroupmember
for_spamlog
for_stats
for_strikes
for_style
for_stylevar
for_stylevardfn
for_subscribediscussion
for_subscribeevent
for_subscribeforum
for_subscribegroup
for_subscribethread
for_subscription
for_subscriptionlog
for_subscriptionpermission
for_tachyforumcounter
for_tachyforumpost
for_tachythreadcounter
for_tachythreadpost
for_tag
for_tagcontent
for_tagsearch
for_template
for_templatehistory
for_templatemerge
for_thread
for_threadrate
for_threadread
for_threadredirect
for_threadviews
for_thread_serviceupdate
for_upgradelog
for_user
for_useractivation
for_userban
for_userchangelog
for_usercss
for_usercsscache
for_userfield
for_usergroup
for_usergroupleader
for_usergrouprequest
for_userlist
for_usernote
for_userpromotion
for_usertextfield
for_usertitle
for_vbseo_blacklist
for_vbseo_likes
for_vbseo_linkback
for_vbseo_serviceupdate
for_visitormessage
for_visitormessage_hash
for_vsa_logintouser
kingk_bbcm
kingk_bbcm_buttons
xf_addon
xf_admin
xf_admin_log
xf_admin_navigation
xf_admin_permission
xf_admin_permission_entry
xf_admin_search_type
xf_admin_template
xf_admin_template_compiled
xf_admin_template_include
xf_admin_template_modification
xf_admin_template_modification_log
xf_admin_template_phrase
xf_attachment
xf_attachment_data
xf_attachment_view
xf_ban_email
xf_bb_code_media_site
xf_bb_code_parse_cache
xf_captcha_log
xf_captcha_question
xf_code_event
xf_code_event_listener
xf_content_spam_cache
xf_content_type
xf_content_type_field
xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user
xf_cron_entry
xf_data_registry

 

[Paul B]

It looks like you have a mixed database there with tables from both installs.
Additionally, the number of XenForo tables is incomplete.

I would recommend doing a fresh install of XenForo using a new database and proceeding from there.

 

[zastavra]

Really? How did that happened?

The forum is live since 14 Dec.

 

[Paul B]

My guess is you installed XenForo into the existing database.
Or you installed something else into the XenForo database.

Either way you have tables from multiple systems in the same database.

 

[Adam Howard]

I'm puzzled how you did this....

A correct import should have been leaving the vBulletin database alone and having XenForo installed in it's own database. You should never have installed them into the same database or merged them in any way, except for the importer which would have "converted" your vBulletin data to your XenForo data.

Assuming you have no add-ons installed in your XenForo install... It could be technically possible to weed through the vBulletin tables and remove them. I've done that for someone who did the same thing I think you did... But it would be a little timely.

 

[Jeremy]

Depending on how you configure your XenForo installation, it is very possible to utilize the same Database, Adam. It, however, is not the recommended method.

 

[Adam Howard]

Depending on how you configure your XenForo installation, it is very possible to utilize the same Database, Adam. It, however, is not the recommended method.

Never said it was impossible. Not sure where you got that from.

Did however say or imply that it wasn't exactly the way your should go about it though (ie... not recommended).

 

[Paul B]

I believe I already said that, several times.

 

[zastavra]

I ve intalled it first in my testing site in a new database named test*** importing latest vb backup named vb***.sql

Then I created new database for the live site named xf*** importing again latest vb backup named vb2***.sql

test*** and xf*** have same structure now.

I dont think that is my mistake.

 

[Paul B]

Just to clarify, did you use the import function in phpMyAdmin, to import the database?

 

[zastavra]

No, I always use ssh, putty.

 

[Paul B]

My point was, importing is done from within the XenForo ACP.

Importing one database to another like this achieves nothing other than to combine all the tables into one database.

http://xenforo.com/help/importing/

 

[zastavra]

What now? Any sudgestions?

 

[Paul B]

Assuming you don't need any of the other tables and you have actually done the import from the ACP, you can remove any tables which were imported from the vBulletin database.