Parallels Virtualization and Automation Software

Download: http://download.swsoft.com/ensim/download/pro/windows/10.0.0/utility2/MySQLPostUpgradeSync.zip

md5sum: 005d9a730b8f2b773508a8cd307308f2



While upgrading Ensim Pro from 4.x to ProX for Windows, you may wish to upgrade MySQL as well. The procedure given below lists out the steps you have to carry out to upgrade MySQL from 4.0.12 to 5.0.

1. Remotely logon to the system where you wish to upgrade EPW and MySQL.

2. Open a command window. Navigate to C:\mysql\bin. Start a mysql session and set the mysql root user password to blank.

3. Take a dump of the existing mysql databases using the following command

mysqldump -u root --all-databases --complete-insert > test.sql

Where test.sql is the name of the dump file that will be created.

4. Stop the MySQL service on the system by the following command

Net stop mysql

5. Now we need to remove the existing mysql service entry. So in the same command window type the following command:

c:\mysql\bin\mysqld --remove

6. Close the command window. Now navigate to Add/Remove Programs and uninstall mysql 4.0.12

7. Restart the server. This is mandatory.

8. When the server comes online, install mysql 5.0.18 in c:\mysql. Select custom installation when prompted to choose the type of installation, and change the installation path for mysql to c:\mysql. All other options during the MySQL installation are the same as specified in the Ensim Pro 10.0.0 for Windows 2003 Installation and Upgrade Guide ( Appendix A : Installing Add-ons For Cold Fusion, Imail, MySQL; page 35/54). Keep the root user password blank.

9. Once mysql is installation is complete, open a command window and start a mysql session. Load the dump using the following command.

Source c:\mysql\bin\test.sql

This will start importing the dump on the new MySQL installation. Let it complete. You will see a lot of messages with ‘ERROR: ……. ‘. Please ignore them. Once the dump completes, close the mysql session. Restart the mysql service using the command

Net stop mysql

Net start mysql

Without loading the dump, the mysql upgrade will not take effect, and the EPW upgrade process will not proceed.

10. Open the file my.ini from the location c:\mysql. Add the following line in the mysqld section

old-passwords

11. Restart the mysql service.

12. Upgrade EPW on the server to ProX using the following command

EPW1000Patch.exe <license key>

13. Unzip the utility from the location where you have copied it on the server. Open a command window and navigate to the folder where the utility is located. Execute the utility

                        C:\utility>MySQLPostUpgradesync.exe

This will set all the requisite permissions required for mysql 5.0.18 to work with EPW 10.0.0

14. Restart the mysql service.

15. Start a mysql session and set the root user password to whatever you wish to set it to.

Additional information :

Upgrading MyODBC from MyODBC 3.51.06 to MyODBC 3.51.12

Important : Please perform this procedure only after completing the MySQL upgrade and ProX upgrade.

In case you wish to upgrade MyODBC from the existing version to the one supported in ProX ( MyODBC 3.51.12-a), please follow the steps given below :

1. Navigate to Add/Remove Programs in the Windows console.

2. Select MyODBC and click on the remove button. Follow the steps in the uninstall wizard, keeping the default options.

3. Restart the server.

4. Now install MyODBC 3.51.12-a. The installer for this is available in the following URL:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

5. After the installation of MyODBC is complete you will be able to see it in the programs list under Add/Remove Programs.