BW Rox to Drupal database migration: Difference between revisions

[[Wiki.trustroots.org]] is an independent wiki with information for people who are actively exchanging hospitality.
No edit summary
No edit summary
Line 1: Line 1:
Trying to get an idea of what needs to be migrated and how...
Trying to get an idea of what needs to be migrated and how...


mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }'
Using <tt>mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }'</tt> as a starting point.


==Work in progress==
<pre>
user
members
</pre>
== (kinda) DONE ==
<pre>
faq
faqcategories
</pre>




== Not clear yet ==
<pre>
<pre>
NbMembersByCities
NbMembersByCities
Line 42: Line 55:
donations
donations
ewiki
ewiki
faq
faqcategories
feedbackcategories
feedbackcategories
feedbacks
feedbacks
Line 85: Line 96:
logs
logs
meetings
meetings
members
 
members_groups_subscribed
members_groups_subscribed
members_roles
members_roles
Line 156: Line 167:
trip_to_gallery
trip_to_gallery
urlheader_languages
urlheader_languages
user
 
user_friends
user_friends
user_inbox
user_inbox
Line 170: Line 181:
words_use
words_use
</pre>
</pre>


{{bw}}
{{bw}}

Revision as of 15:30, 25 August 2011

Trying to get an idea of what needs to be migrated and how...

Using mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }' as a starting point.


Work in progress

user
members

(kinda) DONE

faq
faqcategories


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
cryptedfields
dbversion
donations
ewiki
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_friends
user_inbox
user_outbox
user_seq
user_settings
v_cities
verifiedmembers
volunteer_boards
volunteers_reports_schedule
wEnglish
words
words_use



BeWelcome Logo.jpg
This page is written in the context of BeWelcome.