|
MySQL database on Windows 2000: msg#00085db.mysql.windows
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> |
|---|---|---|
| Previous by Date: | RE: mysql -> ODBC -> envelopes in Word: 00085, Public Folder: MySQL |
|---|---|
| Next by Date: | RE: Demande de confirmation d'inscription à mysql-france : 00085, Public Folder: MySQL |
| Previous by Thread: | mysql -> ODBC -> envelopes in Wordi: 00085, Doru-Catalin Togea |
| Next by Thread: | RE: Demande de confirmation d'inscription à mysql-france : 00085, Public Folder: MySQL |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |