How to upgrade MySQL_MySQL in Windows

How to upgrade MySQL in Windows:

1. you should back up the current MySQL installation before upgrading.

2. download the latest MySQL version for Windows.

3. you must stop the server before upgrading MySQL.

If the server is installed as a service, you must stop the service using the following command in the command line at the command prompt:

C:> net stop mysql if the MySQL server is not a service, run the following command to STOP the server:

C:> C: Program FilesMySQLMySQL Server 5.1 inmysqladmin-u root shutdown4.

4. when you upgrade MySQL from 4.1.5 to MySQL 5.1 or from MySQL installed in the Zip file to MySQL installed in MySQL Installation Wizard (Installation help, you must manually uninstall the previously installed MySQL service.

To uninstall the MySQL service, run the following command:

C:> C: mysqlinmysqld -- remove

If you do not want to uninstall the existing services, MySQL Installation Wizard (Installation help) will not correctly install the new MySQL service.

5. if you use MySQL Installation Wizard (Installation help), refer to the description of "use MySQL Installation Wizard" to start the help.

6. if you use a Zip file to install MySQL, extract the file. You can overwrite the existing MySQL installation (usually in C: mysql), or install it to another directory, such as C: mysql4. It is recommended to overwrite the original installation.

7. restart the server. If you run the MySQL service, you can use net start MySQL and directly call mysqld.