BW Rox to Drupal database migration: Difference between revisions
No edit summary |
No edit summary |
||
Line 16: | Line 16: | ||
** cryptedfields | ** cryptedfields | ||
[http://drupal.org/node/1175562 SOLVED D6 user password import to D7] | [http://drupal.org/node/1175562 SOLVED D6 user password import to D7] | ||
====todo==== | |||
* comments | |||
* feedbacks | |||
* feedbackcategories | |||
* members_roles | |||
* members_updating_status? | |||
* donations? | |||
== To import == | == To import == | ||
Line 21: | Line 31: | ||
* user_friends | * user_friends | ||
* verifiedmembers | * verifiedmembers | ||
=== Geo === | |||
Maybe this can actually be done through a Drupal module + some service, instead of importing. | |||
<pre> | |||
geo_hierarchy | |||
geo_location | |||
geo_type | |||
geo_usage | |||
geonames_admincodes | |||
geonames_alternate_names | |||
geonames_cache | |||
geonames_cache_backup | |||
geonames_countries | |||
geonames_timezones | |||
</pre> | |||
=== Groups === | |||
Nice but not essential: | |||
* groups | |||
* groups_locations | |||
* groupshierarchy | |||
* members_groups_subscribed | |||
* membersgroups | |||
* members_tags_subscribed | |||
* members_threads_subscribed | |||
=== Possibly optional? === | === Possibly optional? === | ||
== Kinda done == | == Kinda done == | ||
Line 90: | Line 128: | ||
gallery_items_to_gallery | gallery_items_to_gallery | ||
gallery_seq | gallery_seq | ||
groups | groups | ||
groups_locations | groups_locations |
Revision as of 00:02, 26 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
- ewiki => bw_wikipage
Users
- user => Drupal users
- members => Drupal profile
- addresses
- cryptedfields
SOLVED D6 user password import to D7
todo
- comments
- feedbacks
- feedbackcategories
- members_roles
- members_updating_status?
- donations?
To import
Essential
- user_friends
- verifiedmembers
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
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
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 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.