Sidebar

How do I migrate from a H2 Database to MySQL?

+1 vote
2.1K views
asked Mar 27, 2015 by amanda-w-3695 (4,840 points)
edited Mar 27, 2015 by amanda-w-3695
What are the steps that need to be taken in migrating from a H2 Database to Mysql?

1 Answer

+1 vote

NOTE: Be sure that all messages are processed in QIE.  If the messages are in processing or if there is a large amount of errors and the DB is migrated, the messages will be lost! 

Use the following link to get all the necessary files:

               https://www.qvera.com/mysqlDownload.html

               https://www.qvera.com/mysqlDownload32.html

 

1) If possible, export the entire configuration of QIE by going to Application >> Export Configuration >> Check the checkbox next to 'Qvera Interface Engine'. If this is not possible, make sure there is a recent backup that can be imported later in the process. 

 

2) Stop QIE in the Service Manager.

 

3) Install MySQL Server.

   - Execute 'mysql-5.5.42-win32.msi'

   - Stop the MySQL Windows Service

   - Edit "C:\Program Files\MySQL\MySQL Server 5.5\my.ini" and Edit/Add line max_allowed_packet= to have a value of 64M, make sure that it is after the '[mysqld]' line, but before the '[client]' tag line.

     NOTE: if you are installing the 32bit installer on a 64bit machine, then the location of the my.ini will be in "C:\Program Files (x86)\MySQL\MySQL Server 5.5\my.ini"

   - Start the MySQL Windows Service

 

4) Install MySQL Workbench

   - Execute 'mysql-workbench-community-6.1.7-win32.msi' (This will install the MySQL Workbench)

 

5) Configure QIE with MySQL JDBC Connector.

   - Copy 'mysql-connector-java-5.1.34-bin.jar' to the "QIE Home"/lib directory

   - Edit "QIE Home"/libs.txt file and add a line pointing to "QIE Home"/lib/mysql-connector-java-5.1.34-bin.jar

 

6) Create QIE user and Database.

   - Execute 'createQieDatabase.bat' (This will create a user qie, with a password qie.  If you want to use a different password, you will need to change it in the 'createQieDatabase.sql' script)

     NOTE: If you installed the 32bit MySQL on a 64bit machine, then you will execute 'createQieDatabasex86.bat' instead

   - You will be prompted for a password.  The password you will use is the one you set during the installation of MySQL.

 

7) Go back into QIE Service Manager.

   - Go into the Startup tab.  Within Arguments, change the Dconnection.driver, Dconnection.url, and Dhibernate.dialect.

          Example:

        -Dconnection.driver=com.mysql.jdbc.Driver

        -Dconnection.url=jdbc:mysql://localhost:3306/qie

        -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect

 

8) Once the changes are applied, start the Service Manager again. 

 

9) Import a backup from the previous day or the export that was done at the start of this process.

 

10) Once the import is complete, start up the channels that are needed. 

answered Mar 27, 2015 by amanda-w-3695 (4,840 points)
edited Mar 27, 2015 by amanda-w-3695
...