logo       

MySQL database on Windows 2000: msg#00085

db.mysql.windows

Subject: MySQL database on Windows 2000

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.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10554@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise