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.