MySQL Install

Migrating simple Mysql data (ie English) from 4.0.x to 4.1.x.

Upgrade MySQL 4.0.x to 4.1.x

In my case I will be upgrading from 4.0.27. As a general rule, MySQL recommends that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0.

• Before upgrading you might want to test (for a few days?), see: MySQL 4.0 to 4.1 Upgrade Testing Mode
• Also read: Notable Change in MySQL 4.1

1) Choose an installation package and Download it.

2) I picked the "Essentials Package".
See Using the MySQL Installation Wizard

First make sure MySQL is not running (with for example the command: C:\mysql\bin\mysqladmin -u root -ppassword shutdown).

Install mysqld server with the default service name MySQL: c:\mysql\bin\mysqld --install

As of 4.0.2, you can also add a service name, like: c:\mysql\bin\mysqld --install MySQL4026

As of MySQL 4.0.3, if a service name is given, you can also specific the location of the option file with:
c:\mysql\bin\mysqld --install MySQL4026--defaults-file=c:\mysql\my.ini

Several visible behaviors have changed between MySQL 4.0 and MySQL 4.1 to fix some critical bugs and make MySQL more compatible with standard SQL. These changes may affect your applications.

Some of the 4.1 behaviors can be tested in 4.0 before performing a full upgrade to 4.1. This gives you the 4.1 behavior for the most critical changes. That way you can test the most new behaviors in 4.0 to make sure that your applications work with them. This helps you have a smoother transition when you perform a full upgrade to 4.1 later.