Migrating Linux/HSQLDB install to Windows/MySQL

musper — Mon, 03 Mar 2008 17:28:53 GMT

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 comp

Re: Migrating Linux/HSQLDB install to Windows/MySQL

ashokkumarc — Sat, 21 Mar 2009 06:03:55 GMT

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

topic Migrating Linux/HSQLDB install to Windows/MySQL in Alfresco Archive

Migrating Linux/HSQLDB install to Windows/MySQL

Re: Migrating Linux/HSQLDB install to Windows/MySQL