Hi,
I am looking for migration tools for database migration from DB2 9.7 to MySQL 5.5. As DB2 is no longer supported for Confluence 5.x we decided to switch to MySQL. XML Backup is not an option as we have large datasets.
Has anybody experiences on this topic?
Thanks!
Nina
Hey Nina,
One approach you can try is the following:
Once you do the procedure in test and works all you need to do is to repeat in a production server.
In case you have a medium to big instance (500 users or more), let me know so I can provide you a little different set of steps since the above might not work for a large instances with several attachmetns due to out of memory errors.
Hi David,
thanks for the answer! We already tried the XML Backup but had to kill the process before even starting the export as CPU went up to 100% while rendering the pagetree. It is a large space with 88.233 pages.
Regards,
Nina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sometimes we have to do some kind of such migrations for our customers and found the workaround: we make a copy of instance with database etc into amazone ec2 server - create that one much larger for memory and with set of CPU cores - then make the backup there - then restore on the new configuration there - and then clone to normal instance. Even for huge instances that will cost ~10-20 dollars if do that fast.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Nina, Based on that that bellow procedure: 1 - Generate a xmlbackup without attachments. 2 - Install a fresh Confluence on the same version as production. 3 - Make sure to install this new confluence with the same <Confluence Home> directory structure as production (if the <Confluence Home> is in c:\atlassian\<confluence Home> the target server needs to be exact the same). 4 - Once you see the input license page, shutdown Confluence. 5 - Follow the below guide so you can increase confluence memory as much as you can in the new installation server: https://confluence.atlassian.com/display/CONFKB/How+to+Fix+Out+of+Memory+Errors+by+Increasing+Available+Memory#HowtoFixOutofMemoryErrorsbyIncreasingAvailableMemory-Step2:IncreaseAvailableMemory 6 - After you do that start Confluence again and try to import the xml backup without attachments. 7 - Once you are done shutdown confluence again. 8 - Copy the attachments folder from production and drop it into your new <Confluence Home> directory. # Start Confluence and check if your attachments are there. # Profit! Let me know if that works. Thanks and Regards, David|Confluence Support Engineer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nina,
I heard about this product that promises what you're trying to achieve:
http://www.ispirer.com/products/db2-to-mysql-migration
You might want to have a look in their demo and free express version.
Cheers,
WZ
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.