BW Rox to Drupal database migration
- See also Set up BW Drupal
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
- ewiki => bw_wikipage
Users
- user => Drupal users
- members => Drupal profile
- addresses
- cryptedfields
Passwords
SOLVED D6 user password import to D7doesn't work- we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in
- imho passwords are secondary. It will be super easy for the users to request a new password once we do the final change - not worth the time Philipp 00:21, 16 September 2011 (UTC)
User Relationships
tables:
- comments (started)
- feedbacks
- feedbackcategories
- verifiedmembers
need to be exportable
todo
members_roles?
- members_updating_status?
- donations?
To import
Geo
Maybe this can actually be done through a Drupal module + some service, instead of importing.
geo_hierarchy geo_location geo_type geo_usage geonames_admincodes geonames_alternate_names geonames_cache geonames_cache_backup geonames_countries geonames_timezones
yes, do not import
Groups
Nice but not essential:
- groups
- groups_locations
- groupshierarchy
- members_groups_subscribed
- membersgroups
- members_tags_subscribed
- members_threads_subscribed
Possibly optional?
Kinda done
- faq
- faqcategories
Used for translations
- words
Not needed
user_friends
Not clear yet
NbMembersByCities - not needed ~~~ 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 - not needed ~~~ cal_eventdata - not needed ~~~ cal_events - not needed ~~~ cal_tags - not needed ~~~ chat_messages - not needed ~~~ chat_room_moderators - not needed ~~~ chat_rooms - not needed ~~~ chat_rooms_members - not needed ~~~ cities - not needed ~~~ comments comments_ofthemomment_votes core_session_expiry core_sessions counters_cities_nbmembers - not needed ~~~ counters_regions_nbcities - not needed ~~~ counters_regions_nbmembers - not needed ~~~ 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 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 - not needed ~~~ old_t_regions - not needed ~~~ oldvisits - not needed ~~~ online - not needed ~~~ 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 - not needed ~~~ sqlforvolunteers - not needed ~~~ 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 - not needed ~~~
Useful info
- This page is written in the context of BeWelcome.