Tickets :: Comment on [#6814] problem of upgrade turba from 2.1.7 to 2.2

* Your Email Address
* Spam protection	Enter the letters below: . ..__ .__ .___. __. \|_/ \| \[__) _/ (__ \| \\|__/\| ./__..__)
Comment	> Here are the complete upgrade shell sripts: > > > > #!/bin/bash > > Wait () { > > echo -n "$STEP Done!!" > > echo > > } > > > > HORDE="/usr/local/apache/horde-rc" > > HD="/root/bin/upgrade-horde3.2" > > S_DB="horde317" > > D_DB="horde32 > > # Share not stable for SQL in Horde-3.2 > > USE_SHARE="N" > > > > cd $HD > > > > STEP="Duplicate Database" > > echo "Duplicate Database from $S_DB to $D_DB" > > echo "DROP DATABASE $D_DB;" >/tmp/Recreate_db.sql > > echo "CREATE DATABASE $D_DB;" >>/tmp/Recreate_db.sql > > mysql </tmp/Recreate_db.sql > > /usr/local/bin/mysqldump --opt $S_DB >/tmp/$S_DB.sql > > mysql $D_DB </tmp/$S_DB.sql > > Wait > > > > # HORDE > > STEP="Horde upgrade scripts" > > cd $HORDE/scripts/upgrades > > mysql $D_DB<./3.1_to_3.2.mysql.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./convert_datatree_groups_to_sql.php > > php -f ./convert_datatree_perms_to_sql.php > > ;; > > esac > > Wait > > > > # NAG > > STEP="Nag upgrade scripts" > > cd $HORDE/nag/scripts/upgrades > > mysql $D_DB<./2.1_to_2.2.sql > > php -f ./2006-04-18_add_creator_and_assignee_fields.php > > mysql $D_DB<$HD/upg_nag.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > > > Wait > > > > # MNEMO > > STEP="Mmemo upgrade scripts" > > cd $HORDE/mnemo/scripts/upgrades > > mysql $D_DB<./2.1_to_2.2.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > > > Wait > > > > # TREAN > > STEP="Trean upgrade scripts" > > cd $HORDE/trean/scripts/sql > > mysql $D_DB<trean.sql > > cd $HORDE/trean/scripts/upgrades > > php -f ./2006-12-29_sql_bookmarks.php > > php -f ./2006-12-29_cleanup.php > > Wait > > > > # WHUPS > > STEP="Whups upgrade scripts" > > cd $HORDE/whups/scripts/upgrades > > mysql $D_DB <./2006-07-12_add_due_date.sql > > mysql $D_DB <./2006-08-04_drop_subjectlist.sql > > mysql $D_DB <./2007-01-16_add_queries.sql > > mysql $D_DB <./2007-01-16_add_ticket_dates.sql > > mysql $D_DB <./2007-01-16_drop_searches.sql > > php -f ./2007-01-16_query_share_updates.php > > php -f ./2007-01-16_cache_calculated_dates.php > > mysql $D_DB <./2007-01-20_add_indexes.sql > > mysql $D_DB <./2007-09-07_rename_listeners_table.sql > > mysql $D_DB <./2007-12-09_add_slugs.sql > > mysql $D_DB <./2007-12-12_additional_indexes.sql > > mysql $D_DB <./2008-02-27_add_defaults.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > mysql $D_DB <./2008-04-29_add_sql_share_tables.sql > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > Wait > > > > # KRONOLITH > > STEP="Kronolith upgrade scripts" > > cd $HORDE/kronolith/scripts/upgrades > > mysql $D_DB<./2.1_to_2.2.sql > > php -f ./2006-08-20_fix_recur_int_fields.mysql.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > Wait > > > > # TURBA > > STEP="Turba upgrade scripts" > > cd $HORDE/turba/scripts/upgrades > > php -f ./2007-06-17_flatten_shares.php > > php -f ./2.1_to_2.2_sql_schema.php > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./2.1_to_2.2_add_sql_share_tables.sql > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > Wait > > > > # ANSEL > > STEP="Ansel upgrade scripts" > > cd $HORDE/ansel/scripts/upgrades > > php -f ./2006-11-27_sql_images.php > > php -f ./2006-11-27_datatree_to_sql_renames.php > > php -f ./2006-11-27_fix_default_images.php > > php -f ./2006-11-27_cleanup.php > > mysql $D_DB <./2008_01_07_add_galleries.sql > > php -f ./2008_01_07_sql_galleries.php > > php -f ./2008_01_28_clean_datatree.php > > mysql $D_DB <./2008_02_04_add_images_and_slugs.sql > > php -f ./2008_02_04_add_initial_image_counts.php > > mysql $D_DB <./2008_02_29_fix_category_defaults.sql > > mysql $D_DB <./2008_03_18_add_gallery_age.sql > > mysql $D_DB <./2008_03_19_add_gallery_download.sql > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > mysql $D_DB <./2008-04-28_add_sql_share_tables.sql > > php -f ./2008-04-28_sql_share_migration.php > > ;; > > esac > > Wait > > > > # INGO > > STEP="Ingo" > > cd $HORDE/ingo/scripts/sql > > mysql $D_DB<./ingo.sql > > cd $HORDE/ingo/scripts/upgrades > > php -f ./convert_prefs_to_sql.php </etc/mail/login > > cd $HD > > mysql $D_DB <./convert_spam.sql > > cd $HORDE/ingo/scripts/upgrades > > case $USE_SHARE in > > y\|Y) > > echo -n " processing ..." > > php -f ./convert_datatree_shares_to_sql.php > > ;; > > esac > > > > # For ingo 2.x > > #php -f ./convert_imp_filters.php </etc/mail/login > > Wait > > > > echo "Upgrade completed !"
Attachment
Watch this ticket

Saved Queries