Community
Products
Confluence
Questions
Is there a solution to automatically backup & restore Confluence?

Is there a solution to automatically backup & restore Confluence?

C. Faysal Jan 17, 2013

for Jira i built a script that modifies an existing jiraDBdump:

change Hostname
change CrowdServerName
update License (change to developer)
rsync $Jira_Home/data (from productive to backup host)
shut down JIRA
insert the modified dump into to backup DB
start Jira

works as expected.

i want to build something similar for confluence.

can this be done the same way? if i take a look at the sqldump (large file) i can tell it is not that easy and comfortable like it is for jira.

any ideas/suggestions on this one?

regards

2 answers

1 accepted

4 votes

Alejandro Conde Carrillo Jan 17, 2013

Hi.

I am talking from the top of my head, so take this as a guideline more than a procedure.

If you are usig standalone Confluence, this procedure would make sense for me:

Copy data directory
Modify database settings and license in the file <confluence_data>/confluence.cfg.xml
Copy installation directory
Modify location of the data directory in <confluence_install>/confluence/WEB-INF/classes/confluence-init.properties
Change ports in the file <confluence_install>/conf/server.xml
Restore database dump
Chage Server Base URL in the BANDANA table. Bandana Key is atlassian.confluence.settings and the value is withing the XML.
To avoid problems on startup I would clear the plugin cache.

After that procedure, you should be able to start Confluence. Please remember that I haven't tested this procedure, but I believe that should make it. You can probably simplify it if you use the same paths and ports.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

C. Faysal Jan 17, 2013

Hi alex. Thanks for participatin. I didn't knew the license could be changed that way. Also i already found the kb article about how to change server base url manually. Is there no other than update the entire xml block?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Alejandro Conde Carrillo Jan 18, 2013

You could replace the string directly in the DB, many DB servers offer options for replace a string withing a field.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

C. Faysal Jan 20, 2013

hi alex.

can you please tell me why inside atlassian.confluence.settings the <webdavPassword> is in plaintext?

what is <webdavuser> used for ?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

C. Faysal Jan 20, 2013

ok i got my script cloning confluence on a backup host now. :)

confluenceSQLdump and data/attachment DIR is synced via cron hourly to the backup host

here are the steps it does:

unzip the dump
stop confluence
insert the dump

execute two queries

mysql -u&lt;user&gt; -p&lt;pwd&gt; confluence -e "UPDATE cwd_directory_attribute SET attribute_value =  REPLACE(attribute_value, '&lt;old_hostname&gt;' , '&lt;new_hostname&gt;')"
        
mysql -u&lt;user&gt; -p&lt;pwd&gt; confluence -e "UPDATE BANDANA SET BANDANAVALUE = REPLACE(BANDANAVALUE, '&lt;old_hostname&gt;', '&lt;new_hostname&gt;') where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings'"