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?
regards
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:
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.
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.
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.
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'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.