https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319359#M6360 <P>Hi,</P> <P>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,</P> Fri, 14 Sep 2012 13:46:03 GMT Sarguru_Nathan 2012-09-14T13:46:03Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319359#M6360 <P>Hi,</P> <P>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,</P> Fri, 14 Sep 2012 13:46:03 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319359#M6360 Sarguru_Nathan 2012-09-14T13:46:03Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319360#M6361 <P>Hi,</P> <P>I would separately manage the migration from MySQL to PostgreSQL and the upgrade from 5.4 to 5.6.</P> <P>About the upgrade, see <A href="http://doc.nuxeo.com/x/yIWo">How to upgrade Nuxeo</A>.</P> <P>About the database change, simply reuse the same data directory and feed the PostgreSQL database with a SQL dump from MySQL.</P> <P>Note, there are many other possibilities and depending on your needs you could also used one of the following tools and features:</P> <UL> <LI><A href="http://doc.nuxeo.com/x/zQQz">Nuxeo Importer Core</A></LI> <LI><A href="http://doc.nuxeo.com/x/swQz">How to replicate Nuxeo repository</A></LI> <LI><A href="http://doc.nuxeo.com/x/owGW">Export</A> / <A href="http://doc.nuxeo.com/x/AwRc">Import</A> features</LI> <LI>migration using <A href="http://doc.nuxeo.com/x/Roao">CMIS</A></LI> <LI>write a <A href="http://doc.nuxeo.com/x/14Wo">Nuxeo Shell</A> migration script</LI> <LI>...</LI> </UL> Fri, 14 Sep 2012 15:09:32 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319360#M6361 Julien_Carsique 2012-09-14T15:09:32Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319361#M6362 <P>Hi,</P> Fri, 14 Sep 2012 16:55:37 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319361#M6362 Sarguru_Nathan 2012-09-14T16:55:37Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319362#M6363 <P>Hi,</P> Sat, 15 Sep 2012 13:16:26 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319362#M6363 Sarguru_Nathan 2012-09-15T13:16:26Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319363#M6364 <P>It seems you didn't install all the required modules</P> Fri, 12 Oct 2012 11:25:28 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-4-to-5-6-migration-with-mysql-to-postgres-db-backend/m-p/319363#M6364 Julien_Carsique 2012-10-12T11:25:28Z