Need to migrate confluence wiki to another server with mysql database

[Ankush Borse]

Hi, 
I have 2 old servers, on one server confluence/wiki is installed and on another server mysql database is installed.
So, we are going to decommissioned those both servers. 
So, before decommissioned I want to migrate both, i. e. Mysql database and confluence/wiki to another servers.
So, can you please help me here, how to do it. 
Regards, 
Ankush Borse 

[Shankar Asam {Appfire} · Accepted solution]

Hi Ankush,

If you're going to migrate confluence and mysql db (confluence db) to another servers, here are the procedure (high level) 

Backup:

• Backup your confluence install & home directories and transfer them to new server.
• Backup or run mysqldump on mysql server to take the confluence db backup and transfer it to the new mysql server.

Restore:

• on the new mysql server, create a new db (similar name as your old db , db user / password) and then restore the backup file you've taken before. 
• on the confluence server, verify the path to your confluence home directory (check confluence-install-directory/confluence/WEB-INF/classes/confluence-init.properties). This should point to your JIRa home directory path.
• verify or modify confluence.cfg.xml file (in confluence home directory) to include correct db hostname, db name , user, password (incase they are not same).
• Make sure the JAVA is installed and available to the user who owns the confluence.
•  Start the confluence and access it

For further info, please see:- https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html

[Ankush Borse]

Will it worked if I copy confluence install & home directories from CentOS 6 server to new server with CentOS 7.

How can it create binary i.e. We can use it for restart/stop

e.g. service confluence restart

Regards, 

AB

[Shankar Asam {Appfire}]

Yes, you can copy the confluence install & home directories to new server (centOS 7). Please make sure to remember the installation path so you can use them in service or startup script. Please see below Atlassian article on how to create a start up script;

https://confluence.atlassian.com/doc/start-confluence-automatically-on-linux-183148.html

[Suresh]

Hi Shankar,

• Backup or run mysqldump on mysql server to take the confluence db backup and transfer it to the new mysql server.
• bin/mysql -u confluenceuser -p confluencedb < /opt/gtnexus/db-backup/confluence_backup_26052019.sql;
• I have taken mysqldump and while importing to the empty db I am getting errors as below. Though I have changed the size innodb_log_file_size in my.cnf file.
  

ERROR 1118 (42000) at line 9030: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.

I got struck with these error can any one help me on this?

Regards,
Suresh