Windows 2000, XP and NT 4.0 Installation If you're upgrading an existing MySQL installation, there are some things you need to do first. If you're doing a new install, jump down to the relevant section.When changing from 3.23 to 4.0 and you use shared libraries like DBD-mysql and MySQLdb, you'll probably have to recompile them. See the manual for more details.If 3.23 to 4.0: Check startup scripts and configuration files for deprecated options. To find them, follow this link to the manual and then scroll down a bit. Open up a Command Prompt window. The default location is: Start | Programs | Accessories | Command Prompt. Switch to the drive which has your present mysql\bin directory. Eg: L:\> c: Move into the MySQL bin directory: cd mysql\bin Dump your data: mysqldump -u root -p --add-drop-table -A -r c:\secure\myold.sql Stop the MySQL service: net stop mysql If changing from 3.23 to 4.0 and you have some tables in the old ISAM format, you'll need to change them to the new MyISAM format. There are several ways to do this. Here are three possibilities: sed: sed 's/^) TYPE=ISAM/) TYPE=MyISAM/' c:\secure\myold.sql > c:\secure\mynew.sql Perl: perl -wpe 's;^\) TYPE=ISAM;\) TYPE=MyISAM;i' < c:\secure\myold.sql > c:\secure\mynew.sql Your favorite text editor: open c:\secure\myold.sql then do a search and replace on TYPE=ISAM to TYPE=MyISAM. Save the file as mynew.sql. Remove the existing service by typing in mysqld --remove Jump up two directory levels: cd ..\.. Rename your old mysql directory as a backup: ren mysql myold
然后在注册表里，把所有有关mysql 的项都删除
If you're upgrading an existing MySQL installation, there are some things you need to do first. If you're doing a new install, jump down to the relevant section.When changing from 3.23 to 4.0 and you use shared libraries like DBD-mysql and MySQLdb, you'll probably have to recompile them. See the manual for more details.If 3.23 to 4.0: Check startup scripts and configuration files for deprecated options. To find them, follow this link to the manual and then scroll down a bit.
Open up a Command Prompt window. The default location is: Start | Programs | Accessories | Command Prompt.
Switch to the drive which has your present mysql\bin directory. Eg: L:\> c:
Move into the MySQL bin directory: cd mysql\bin
Dump your data: mysqldump -u root -p --add-drop-table -A -r c:\secure\myold.sql
Stop the MySQL service: net stop mysql
If changing from 3.23 to 4.0 and you have some tables in the old ISAM format, you'll need to change them to the new MyISAM format. There are several ways to do this. Here are three possibilities:
sed: sed 's/^) TYPE=ISAM/) TYPE=MyISAM/' c:\secure\myold.sql > c:\secure\mynew.sql
Perl: perl -wpe 's;^\) TYPE=ISAM;\) TYPE=MyISAM;i' < c:\secure\myold.sql > c:\secure\mynew.sql
Your favorite text editor: open c:\secure\myold.sql then do a search and replace on TYPE=ISAM to TYPE=MyISAM. Save the file as mynew.sql.
Remove the existing service by typing in mysqld --remove
Jump up two directory levels: cd ..\..
Rename your old mysql directory as a backup: ren mysql myold