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'"
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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