AnsweredAssumed Answered

Backup/Restore/DB issue

Question asked by edk on Feb 4, 2009
Latest reply on Feb 25, 2009 by derek
Currently we have a small Alfresco installation with some documents…. but because:
  1. It wasn't created from svn source

  2. It runs under Tomcat and not JBoss
I want to migrate the content from an Alfresco installation from Labs 3 Final running on Tomcat/MySQL 5.0.24-standard to JBoss 4.2.3.GA/MySQL 5.0.67. To backup to running Alfresco, I stopped the program, dumped the database, and backed up the alf_dir directory - as instructed by .

Now the problem is restoring the content on the new server. I get the following error:
14:12:30,110 INFO  [STDOUT] 14:12:30,110  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:14:31,018 INFO  [STDOUT] 14:14:31,014  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(
        at org.springframework.context.event.SimpleApplicationEventMulticaster$
        at org.springframework.core.task.SyncTaskExecutor.execute(
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(
        at org.apache.catalina.core.StandardContext.listenerStart(
        at org.apache.catalina.core.StandardContext.start(
        at org.apache.catalina.core.ContainerBase.addChildInternal(
        at org.apache.catalina.core.ContainerBase.addChild(
        at org.apache.catalina.core.StandardHost.addChild(
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Node the two minute delay, I dropped and reloaded the database backup before this run

My questions are:
  1. Is the backup procedure correct?

  2. Is there more logging that could shed some light on this?