This is a one-way process. Once the data has been moved to MySQL, there is no process for switching back to the default Hypersonic database. You should only perform the transfer if you are willing to abandon the default database.

Before getting started with the transfer from Hypersonic to MySQL, please follow the ScrumWorks Pro backup procedure.

Please read the MySQL Requirements and Configuration guide before transferring data from Hypersonic to MySQL.

Please note that specific MySQL-related components must be obtained directly from the MySQL web site for licensing reasons. ScrumWorks Pro does not bundle or automatically download MySQL components. For a complete list of needed components, please see the MySQL Requirements section of the documentation.

1. Stop your ScrumWorks Pro Server.
2. Launch mysql-transfer.exe. Note that the transfer tool takes some time to start up since it has to extract the files necessary for it to run.
3. Fill in the required data about your ScrumWorks Pro Server root directory and MySQL database information.

4. The mysql-transfer.exe program will perform the transfer, create the necessary files, and configure the ScrumWorks Pro Server to run with MySQL.

   Note: The transfer process may run for several hours depending on the size of your database.

   To abort the transfer process, use CTRL-C

   If anything goes wrong with the data transfer, the process will abort and you will have a scrumworks-transfer.log file. Your existing data has not been modified and it is safe to restart the ScrumWorks Pro Server with the old database. The scrumworks-transfer.log file may contain relevant information about the reason your transfer failed.

5. Start your ScrumWorks Pro Server. Your ScrumWorks Pro Server is now using a MySQL database.

1. Stop your ScrumWorks Pro Server.

2. Extract the package:

   tar jxvf scrumworks-{version}-mysql-transfer.tar.bz2

3. Change to the scrumworks-transfer directory:

   cd scrumworks-transfer

4. Run the transfer tool:

   ./mysql-transfer.sh

5. Answer the questions about your ScrumWorks Pro Server root directory and MySQL database information.

6. The installation will perform the transfer, create the necessary files, and configure the ScrumWorks Pro Server to run with MySQL.

   Note: The transfer process may run for several hours depending on the size of your database.

   To abort the transfer process, use CTRL-C

   If anything goes wrong with the data transfer, the process will abort and you will have a scrumworks-transfer.log file. Your existing data has not been modified and it is safe to restart the ScrumWorks Pro Server with the old database. The scrumworks-transfer.log file may contain relevant information about the reason your transfer failed.

7. Start your ScrumWorks Pro Server. Your ScrumWorks Pro Server is now using a MySQL database.