Backup and restore

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

tarrinho

Hi,

I'm testing the backup/restore procedure.

********************************
Backup:

Stop tomcat
backup mysql (mysqldump -u alfresco –password="zbr" –all-databases > backup.mysql.`date -I`.sql)

backup alf_data (which is empty)
start tomcat
********************************
Restore:
create a new DB (alfrescoV2)
restore mysql to new DB (mysqlimport alfrescoV2 /opt/backup/backup.mysql.2007-04-24.sql)
restore alf_data
alter .war so it acesses the new DB
start tomcat

*******************

In the logs  got the following error:




INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.x
ml]
Apr 20, 2007 7:03:59 PM org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
Apr 20, 2007 7:04:12 PM org.springframework.web.context.ContextLoader initWebApplicationContext
SEVERE: Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:427)
        at org.alfresco.repo.importer.ImporterBootstrap.onApplicationEvent(ImporterBootstrap.java:654)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplication
EventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationConte
xt.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.ja
va:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRef
reshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at

org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:
49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)


Can anyone help?

sdavis139

Sounds like you need to point Alfresco at your new DB.  Check the settings under

# Database configuration

in $ALF_HOME/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties