1 message in com.mysql.lists.win32MySQL database on Windows 2000
FromSent OnAttachments
Greg Glick17 Feb 2003 08:59 
Subject:MySQL database on Windows 2000
From:Greg Glick (ema@gregglick.com)
Date:02/17/2003 08:59:12 AM
List:com.mysql.lists.win32

Looking for the procedure to upgrade MySQL from 3.23.55 to 4.0 for the Windows platform. Does a script exist for the Windows platform of "mysql_fix_privilege_tables" ? All of my tables are currently MyISAM on 3.23.55.

The MySQL manual has:

Section 2.5.2 Upgrading From Version 3.23 to Version 4.0 In general what you have to do when upgrading to 4.0 from an earlier MySQL version:

Run the script mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables. Edit any MySQL startup scripts or configure files to not use any of the deprecated options listed below. Convert your old ISAM files to MyISAM files with the command: mysql_convert_table_format database. Note that this should only be run if all tables in the given database is ISAM or MyISAM tables. If this is not the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables. Ensure that you don't have any MySQL clients that uses shared libraries (like the Perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed.