Article ID: 2880, created on Oct 29, 2007, last review on Apr 17, 2012

  • Applies to:
  • Pro Control Panel Windows


View Knowledge
Knowledge ID 2304
Product : Ensim Pro X for Windows
Version : 10.0.0
Topic : Upgrade

MySQL upgrade steps during Ensim Pro v4.x to Ensim Pro X upgradation

MySQL upgrade steps during Ensim Pro v4.x to Ensim Pro X upgradation



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


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


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:

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


Related Knowledge

Related Links
Last ModifiedUsageSatisfiedLast Used
7/6/2006 12:47:16 AM147 10/12/2007 4:57:55 AM

8e19bcddff0cc55cafe80c841132ca59 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF