Why a migration script is needed
A database structure change was introduced with Nuxeo 5.3.2 to fix query with operator IN (for more details, see https://jira.nuxeo.com/browse/NXP-5183 ).
Below is an example of structure change:
Sample structure in Nuxeo DM <= 5.3.1
Sample structure in Nuxeo DM >= 5.3.2
See the part CHARACTER SET latin1COLLATE latin1_bin that was added for the column id.
As a consequence, the columns (mainly id) used for foreign key don't have the same definition and it is no more possible to add new constraints, needed by the features of Nuxeo DM. trying to upgrade to Nuxeo DM 5.4.x will raise this error
Steps for the migration
You need to follow the steps below to migrate your database structure:
- download the script upgradeMySQL.sh attached to this page
- edit these properties in the file upgradeMySQL.sh
- change permission for the script to run it
- launch the script
- if everything is fine, you'll have a message to confirm the upgrade was done
Database structure upgraded successfully
Upgrade to Nuxeo DM 5.4.1
Now your database is upgraded, you can test it against Nuxeo DM 5.4.1
Once you've downloaded and unzipped it,
- start it without editing anything: it's needed because you'll need to get the lastest hot fixes to make it work
- follow the wizard steps and register on Nuxeo Connect (needed to download Hot Fixes) if you don't have already an account
- restart
- log in using the default credentials
- navigate to Nuxeo Admin Center > Update Center > Software updates tab
- download and install all availables hot fixes (actually at least the three first ones)
- stop the server
- edit the configuration file nuxeo.conf and set the database parameters
- restart the server
- contemplate that all data are present
Labels:
None