BW Rox to Drupal database migration: Difference between revisions
No edit summary |
|||
Line 15: | Line 15: | ||
== To import == | == To import == | ||
=== Essential === | |||
* user_friends | * user_friends | ||
* verifiedmembers | * verifiedmembers | ||
=== Possibly optional? === | |||
== Kinda done == | == Kinda done == |
Revision as of 19:58, 25 August 2011
Trying to get an idea of what needs to be migrated and how...
mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }' was used as a starting point.
For now this is only about the data migration, not about the presentation of the data.
Work in progress
- user => Drupal users
- members => Drupal profile
- addresses
- cryptedfields
- ewiki => bw_wikipage
To import
Essential
- user_friends
- verifiedmembers
Possibly optional?
Kinda done
- faq
- faqcategories
Used for translations
- words
Not clear yet
NbMembersByCities addresses blog blog_categories blog_categories_seq blog_comments blog_comments_seq blog_data blog_seq blog_tags blog_tags_seq blog_to_category blog_to_tag broadcast broadcastmessages cal_event_to_tag cal_eventdata cal_events cal_tags chat_messages chat_room_moderators chat_rooms chat_rooms_members cities comments comments_ofthemomment_votes core_session_expiry core_sessions counters_cities_nbmembers counters_regions_nbcities counters_regions_nbmembers countries dbversion donations feedbackcategories feedbacks flags flagsmembers forum_trads forums_posts forums_posts_votes forums_tags forums_threads forums_threads_votes func gallery gallery_comments gallery_comments_seq gallery_items gallery_items_seq gallery_items_to_gallery gallery_seq geo_hierarchy geo_location geo_type geo_usage geonames_admincodes geonames_alternate_names geonames_cache geonames_cache_backup geonames_countries geonames_timezones groups groups_locations groupshierarchy groupsmessages guestsonline hcvol_config intermembertranslations languages linklist localvolmessages localvolmessages_location logs meetings members_groups_subscribed members_roles members_tags_subscribed members_threads_subscribed members_updating_status membersgroups memberslanguageslevel membersmeetings membersphotos memberspreferences memberspublicprofiles memberstrads message messages mod_user_apps mod_user_apps_seq mod_user_auth mod_user_auth_seq mod_user_authgroups mod_user_authrights mod_user_groupauth mod_user_grouprights mod_user_implications mod_user_rights mod_user_rights_seq mycontacts notes old_t_cities_old_BW old_t_regions oldvisits online params pendingmandatory plannedtrips polls polls_choices polls_choices_hierachy polls_contributions polls_list_allowed_countries polls_list_allowed_groups polls_list_allowed_locations polls_record_of_choices posts_notificationqueue preferences previousversion privileges privilegescopes proc profilesvisits recentvisits recorded_usernames_of_left_members regions reports_to_moderators rights rightsvolunteers roles roles_privileges shouts shouts_seq specialrelations sqlforgroupsmembers sqlforvolunteers stats tags_threads translations trip trip_data trip_seq trip_to_gallery urlheader_languages user_inbox user_outbox user_seq user_settings v_cities volunteer_boards volunteers_reports_schedule wEnglish words_use
- This page is written in the context of BeWelcome.