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'"
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs