Nuxeo 5.4 to 5.6 migration with mysql to postgres db backend change

Sarguru_Nathan

Hi,

I've been using nuxeo 5.4 with mysql as the backend database.Due to the performance constraints with mysql now I want to move to postgresql. I have now setup a fresh nuxeo 5.6 with postgres as my db. Is there any way by which I can export/import the docs from my old nuxeo (about 150GB of data). The knowledge base article says that I can use nuxeo shell and core-io features for the doc migration but there is not much details about it. Can somebody please point me some existing document or give in your suggestions on doing the same,

Julien_Carsique

Hi,

I would separately manage the migration from MySQL to PostgreSQL and the upgrade from 5.4 to 5.6.

About the upgrade, see How to upgrade Nuxeo.

About the database change, simply reuse the same data directory and feed the PostgreSQL database with a SQL dump from MySQL.

Note, there are many other possibilities and depending on your needs you could also used one of the following tools and features:

• Nuxeo Importer Core
• How to replicate Nuxeo repository
• Export / Import features
• migration using CMIS
• write a Nuxeo Shell migration script
• ...