Hi, for the "non-documentary" tables I just exported them using mysqldump. These tables are the ones related to users/groups, relations, audit, vocabularies and subscriptions. Then I made a few change in the sql script (generated by mysqkdump) to make it compatible with PostgreSQL. I executed this sql script to import tables in my PostgreSQL DB. Execution worked fine (after a few attempts, I admit ;-) ). To migrate the documentary base I used the procedure/tool described [here|http://www.nuxeo.org/xwiki/bin/view/FAQ/ReplicateNuxeoRepository] . I exported my 5.1.6 doc. base using the UI. Then I imported it in a 5.2.1 snapshot using the MBean. I restarted the server and the I could log in and browse in the doc. base without any problems. The problem I reported is that audit service does not store any events due to the exception I reported earlier. BTW I noticed that in 5.1.6 there's only one audit table called nxp_logs. I migrated it without any problem (no duplicate key error, ... during import in PostgreSQL). But I see in 5.2 that there are several tables now. I am going to test with a clean 5.2.1 instance and see if I still get these exceptions. I keep you posted.
Kr. -- Posted by "vdu" at Nuxeo Discussions <http://nuxeo.org/discussions> View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2682#7650> _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
