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

Is there a solution to automatically backup & restore Confluence?

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

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

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

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

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

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'"