AnsweredAssumed Answered

Migrating Linux/HSQLDB install to Windows/MySQL

Question asked by musper on Mar 3, 2008
Latest reply on Mar 21, 2009 by ashokkumarc
I had a rough night wrestling with Alfresco migration from Ubuntu 7.10/HSQLDB to Win/MySQL.

Here are the links and steps which I've took to get complete repository migrated between mentioned two systems.

1.    Migrating from HSQL
   http://wiki.alfresco.com/wiki/Migrating_from_HSQL
   
2.    Export complete source Repository via Alfresco Web Client Administration Console
   http://wiki.alfresco.com/wiki/Export_and_Import#Export_complete_source_Repository_via_Alfresco_Web_Client_Administration_Console
   
3.  Bootstrap destination Repository from ACP files exported from Full Export
   http://wiki.alfresco.com/wiki/Export_and_Import#Bootstrap_destination_Repository_from_ACP_files_exported_from_Full_Export
   
I've started alf_start.bat and all I've got was server output with many errors, obviously failing to start. I was feeling lucky and googled
"java.sql.SQLException: Field 'ID' doesn't have a default value" error, after I've found:
   
4.  Visit all the tables in MySQL Administrator and switch on AUTO_INCREMENT for the primary keys where they are a single ID (long) value.
   http://forums.alfresco.com/viewtopic.php?p=31662&sid=3cfd9ab2999565eaa214ab6b089dbd8e#31662
   
Then I've imported a copy of alf_data from my linux install
   
5.  /alf_data imported to fresh windows alfresco install

6. removed file restore-context.xml from /alfresco/extension and /alfresco/extension/restore folder

Started alf_start.bat just to get a fully working copy of my linux repository running smoothly on windows server.

Hope this isn't sanctioned, and maybe helps someone.

Danijel

Outcomes