I did not update the Platform, but did a fresh install and imported the Database and mongodb from the old server. Find attached my "backup-script" for the database on the old server. I have some where clauses to avoid double ids. You have to check if there is some not default data in the other tables, but these were the tables where there were changes on our system.
Am Mittwoch, 7. September 2016 12:54:13 UTC+2 schrieb javier....@teltek.es: > > Did you update the platform? Im in the same situation. > > El martes, 21 de junio de 2016, 18:14:31 (UTC+2), Walter Brunner escribió: >> >> Hi Puntxo, >> do you have any info about this migration script for the database from >> birch to cypress to dogwood since your post in march? I would also need it >> here, because I didn't manage to upgrade my install and we decided to try >> with a new one. >> Walter >> >> Am Montag, 7. März 2016 16:21:51 UTC+1 schrieb Puntxo: >>> >>> We also need to migrate our production servers from birch release to >>> cypress and then to dogwood. We are trying with test servers and have >>> encountered lots of errors with the migration script. We have fixed some of >>> them with the help of other people comments, but my feeling is that there >>> are so many components involved in the migration process that may vary, >>> version changes, git tags removed, etc. that makes it unpredictable, so it >>> that can either work fine one day or fail the next. Our main worry is that >>> we want to preserve our data, but we don't mind if we loose the >>> configuration settings, because probably we'll have to review them anyway >>> in the new release. So, could be possible to group all the db migrations >>> changes in one or several scripts, so we could migrate only the data using >>> a reliable and not external factors dependent process? Is there any place >>> where we can collect that information? >>> >> -- You received this message because you are subscribed to the Google Groups "General Open edX discussion" group. To view this discussion on the web visit https://groups.google.com/d/msgid/edx-code/a4901e36-97be-4a1f-9042-b3f066101102%40googlegroups.com.
#!/bin/bash mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp auth_group >auth_group.sql #mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp auth_permission --where "id>4" >auth_permission.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp auth_user --where "id>5" >auth_user.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp auth_user_groups >auth_user_groups.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp auth_userprofile --where "id>5" >auth_userprofile.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp certificates_certificategenerationconfiguration >certificates_certificategenerationconfiguration.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp certificates_examplecertificate >certificates_examplecertificate.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp certificates_examplecertificateset >certificates_examplecertificateset.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp contentstore_videouploadconfig >contentstore_videouploadconfig.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp course_action_state_coursererunstate >course_action_state_coursererunstate.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp course_groups_coursecohortssettings >course_groups_coursecohortssettings.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp course_modes_coursemode >course_modes_coursemode.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp course_structures_coursestructure >course_structures_coursestructure.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp courseware_studentmodule >courseware_studentmodule.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp courseware_studentmodulehistory >courseware_studentmodulehistory.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp courseware_xmodulestudentinfofield >courseware_xmodulestudentinfofield.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp courseware_xmodulestudentprefsfield >courseware_xmodulestudentprefsfield.sql #?django_admin_log mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp django_comment_client_permission_roles --where "role_id>4" >django_comment_client_permission_roles.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp django_comment_client_role --where "id>4" >django_comment_client_role.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp django_comment_client_role_users --where "id>4" >django_comment_client_role_users.sql #?django_site mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp instructor_task_instructortask >instructor_task_instructortask.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp mobile_api_mobileapiconfig >mobile_api_mobileapiconfig.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp oauth2_client >oauth2_client.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp shoppingcart_certificateitem >shoppingcart_certificateitem.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp shoppingcart_order >shoppingcart_order.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp shoppingcart_orderitem >shoppingcart_orderitem.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp social_auth_usersocialauth >social_auth_usersocialauth.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp student_anonymoususerid >student_anonymoususerid.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp student_courseaccessrole >student_courseaccessrole.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp student_courseenrollment >student_courseenrollment.sql --where "id>4" mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp student_courseenrollmentallowed >student_courseenrollmentallowed.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp student_loginfailures >student_loginfailures.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp user_api_userpreference >user_api_userpreference.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp wiki_article >wiki_article.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp wiki_articleforobject >wiki_articleforobject.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp wiki_articlerevision >wiki_articlerevision.sql mysqldump --extended-insert=FALSE --complete-insert --no-create-info edxapp wiki_urlpath >wiki_urlpath.sql mkdir mongo cd mongo /usr/bin/mongodump
