(mysql.info) windows-upgrading
Info Catalog
(mysql.info) windows-troubleshooting
(mysql.info) windows-installation
(mysql.info) windows-vs-unix
2.3.14 Upgrading MySQL on Windows
---------------------------------
This section lists some of the steps you should take when upgrading
MySQL on Windows.
1. Review upgrade, for additional information on upgrading
MySQL that is not specific to Windows.
2. You should always back up your current MySQL installation before
performing an upgrade. See backup.
3. Download the latest Windows distribution of MySQL from
`http://dev.mysql.com/downloads/'.
4. Before upgrading MySQL, you must stop the server. If the server is
installed as a service, stop the service with the following
command from the command prompt:
C:\> NET STOP MYSQL
If you are not running the MySQL server as a service, use the
following command to stop it:
C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin" -u root shutdown
* If the MySQL `root' user account has a password, you need
to invoke `mysqladmin' with the -p option and supply the password
when prompted.
5. When upgrading to MySQL 5.0 from a version previous to 4.1.5, or
when upgrading from a version of MySQL installed from a Zip
archive to a version of MySQL installed with the MySQL
Installation Wizard, you must manually remove the previous
installation and MySQL service (if the server is installed as a
service).
To remove the MySQL service, use the following command:
C:\> C:\mysql\bin\mysqld --remove
*If you do not remove the existing service, the MySQL Installation
Wizard may fail to properly install the new MySQL service.*
6. If you are using the MySQL Installation Wizard, start the wizard
as described in windows-install-wizard.
7. If you are installing MySQL from a Zip archive, extract the
archive. You may either overwrite your existing MySQL installation
(usually located at `C:\mysql'), or install it into a different
directory, such as `C:\mysql4'. Overwriting the existing
installation is recommended.
8. If you were running MySQL as a Windows service and you had to
remove the service earlier in this procedure, reinstall the
service. (See windows-start-service.)
9. Restart the server. For example, use `NET START MySQL' if you run
MySQL as a service, or invoke `mysqld' directly otherwise.
10. If you encounter errors, see windows-troubleshooting.
Info Catalog
(mysql.info) windows-troubleshooting
(mysql.info) windows-installation
(mysql.info) windows-vs-unix
automatically generated byinfo2html