Migrating Linux/HSQLDB install to Windows/MySQL

[musper]

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_C...
   
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_expo...
   
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

[ashokkumarc]

hi ,
  i did what ur told but it wont work , finally i got the following error, i must need to migrate hsql to mysql ,
please help me  ,i nned the working procedure

custom-repository.properties file configuration is
dir.root=C:/alfresco2/alf_data

11:16:46,187 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
11:16:49,031 WARN  [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
11:16:53,875 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:16:55,531 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
11:16:56,109 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Store exists - bootstrap ignored: user://alfrescoUserStore
11:16:56,109 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Store exists - bootstrap ignored: system://system
11:16:56,125 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Store exists - bootstrap ignored: workspace://lightWeightVersionStore
11:16:56,125 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Store exists - bootstrap ignored: archive://SpacesStore
11:16:56,140 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Store exists - bootstrap ignored: workspace://SpacesStore
11:16:58,171 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\alfresco2\alf_data
11:16:58,218 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 5 stores.
11:16:58,218 INFO  [org.alfresco.repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
11:16:58,218 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
11:16:58,218 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
11:16:58,218 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventM

ashok