for Jira i built a script that modifies an existing jiraDBdump:
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?
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:
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.
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:
mysql -u<user> -p<pwd> confluence -e "UPDATE cwd_directory_attribute SET attribute_value = REPLACE(attribute_value, '<old_hostname>' , '<new_hostname>')" mysql -u<user> -p<pwd> confluence -e "UPDATE BANDANA SET BANDANAVALUE = REPLACE(BANDANAVALUE, '<old_hostname>', '<new_hostname>') where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings'"
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG