how do i move a database from windows 10 to windows Server 2016

[mouzakirou yaya]

Dear Mr and Misses,

i installed confluence on windows 10 with integrated database , we are curent have troubleshooting with logon and my manager told me to installed again confluence on Windows Server 2016.

please do u have any know how to move my old database to the New Server ? 

Thank you for Help 

[Steve Thornhill]

There are a couple of guides to help you through the process. Take a look at these

https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html

https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

They should help with what you are attempting, let us know if there are any problems.

[mouzakirou yaya]

i have got this link  i will let u know  

Thankyou 

[Shannon S]

From a duplicate thread that Mouzakirou raised:

if i make  this changement in my.cnf  mysql is crasched i dont get any error but mysql doesnt started anymore 

1. • [mysqld]
     ...
     default-storage-engine=INNODB
     ...

   • Specify the value of max_allowed_packet to be at least 256M:

     [mysqld]
     ...
     max_allowed_packet=256M
     ...

   • Specify the value of innodb_log_file_size to be at least 2GB:

     [mysqld]
     ...
     innodb_log_file_size=2GB
     ...

   • Check that the binary logging format is configured to use 'row-based' binary logging.

     [mysqld]
     ...
     binlog_format=row
     ...

[Shannon S]

Hello Mouzakirou,

From your duplicate thread Edit my.cnf to setup MYSQL für connfluence, it appears you are now having an error after editing my.cnf with your database details.

Could you let us know here what changes you made exactly and what error messages you are seeing in your startup logs?

Regards,

Shannon

[Shannon S]

Mouzakirou - please be sure not to accept any answers on the thread unless that reply helped to resolve your issue. This helps other users in the future if they have the same problem.

Thank you for your understanding!

Regards,

Shannon

[Milan Chheda [INFOSYSTA]]

Simple step-by-step:

1. Export the current confluence as XML with attachments. Login as admin, go to General configuration > Backups and Restore. 
2. Once the XML is generated, shut-down Confluence. 
3. Install Confluence on new instance connecting to new database.
4. Copy the XML from step1 to 'restore' directory located in home directory of Confluence
5. During the setup wizard, it will prompt for restoring of data
6. At this step, scroll down to restore, select the XML and click restore.

Data has been migrated.

Note: Assuming, you are migrating to same database (example: SQL server to SQL server)

[mouzakirou yaya]

the Old Server has The Integrated Database  for Confluence Server