Database Migration from Joobb 0.7.7 to Joobb 0.9 w/ JooCM 0.9
All,
Here is the basic notes that I made when I migrated my databases from Joobb 0.7.7 to the current Joobb 0.9 running in conjunction with JooCM 0.9. This allowed me to keep most all of my users and their settings along with all forum posts, categories, custom ranks, ect...
You must FIRST backup all joobb databases for later use then follow all install instructions. Then perform these database modifications after all new databases are installed.
Use a database editor or CLI of your choice to manage your databases. I used PHPMYADMIN myself.
1. Delete table jos_joocm_profiles.
- Copy table structure and data from jos_joobb_profiles into JooCM -->jos_joocm_profiles
- Drop field 'p_signature' from table
2. Delete table jos_joocm_users
- Copy table structure and data from backup 'jos_joobb_users' into JooCM --> 'jos_joocm_users'
- Drop the following fields: posts, role, notify_on_reply, enable_bbcode, enable_emotions, avatar_file, time_zone
- Add the following fields:
- After field 'id', add 'views_count' int(11) NOT NULL default '0'
- After field 'system_emails', add `agreed_terms` tinyint(1) NOT NULL default '0'
- After field 'show_online_state', add `id_avatar` int(11) NOT NULL default '0'
3. Drop any entries in jos_joobb_categories
- upload data into this table from backup
4. Drop table jos_joobb_configs
- upload table structure and data for jos_joobb_configs
- drop the following (4) data items
- id_timezone
- id_timeformat
- view_footer_settings
- avatar_settings
5. Drop data from table jos_joobb_designs
- upload data from backup set
6. Drop table jos_jobb_forums
- upload from backup data table structure and data
- change field #4 from "state" to "status"
- Insert New Field "auth_move" after "auth_delete" --> `auth_move` int(3) NOT NULL default '0'
- Drop field auth_value
- Drop field auth_pollcreate
7. Drop data from table jos_joobb_posts
- upload old table structure and data from backup dataset
- drop field "notify_on_reply" from data set
8. Empty table jos_joobb_ranks (only if you used customized ranks)
- upload from backup dataset the table data
9. Drop table jos_joobb_topics
- upload old table structure and data into database from backup dataset
- drop field "id_moved" from the table
10. Drop table jos_joobb_users
- upload old table structure and data into database from backup dataset
- drop the following data fields:
system_emails, show_email, show_online_state, notify_on_reply, avatar_file, signature, time_zone, time_format fields.
Please feel free to comment if you believe I left something out or made an error. This worked for my Live Site from the best of my note taking! Hey, I'm getting old and mistakes can happen, LOL.
Goodluck,
Jeff
Re: Database Migration from Joobb 0.7.7 to Joobb 0.9 w/ JooCM 0.9
OMG THANKS A LOT that work perfectly i was freaking out cause i didnt find the way to make it work. For those that dont know of sql i leave her a link:
http://users.telenet.be/pecop/sqlr/sqlbasics.html
Sorry for my post in support, i was freaked out.
Regards
Re: Database Migration from Joobb 0.7.7 to Joobb 0.9 w/ JooCM 0.9
Glad that folks are getting some use out of this. 
