At 10:20 -0700 9/2/02, Sqlcoders.com Programming Dept wrote: >Please see http://www.mysql.com/downloads/mysql-4.0.html, >specifically the link for "You can find how to upgrade from MySQL 3.23 Here >(http://www.mysql.com/doc/en/Upgrading-from-3.23.html)" > >..." >In general what you have to do when upgrading to 4.0 from an earlier MySQL >version: > >Run the mysql_fix_privilege_tables to add new privileges and features to the >MySQL privilege tables.
That doesn't help much for Windows, which has no mysql_fix_privilege_tables script. >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. >"... > >HTH, >Dw. > >-----Original Message----- >From: Chuck Amadi [mailto:[EMAIL PROTECTED]] >Sent: 02 September 2002 08:02 >To: [EMAIL PROTECTED] >Subject: Just being prudent - upgrade MySql v3.23 to v4.0.2 > > >Still haven't recieved a simple answer when i unzip the >mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and >override everthing . >as i have working db's so i just would like confirmation prior to >proceeding. > >The MySql Doc's don't clarify this I assume you do but i thought i'll >remain prudent. > >Plz confirm ASAP as I have another MySql Project that'll conbine >Transactions (Innodb) Table & TimeStamp datatype field for all the >Project Tables . > >-- >Regards >Chuck Amadi >ICT Dept Systems Programmer >Rhaglenydd Systemau Adran ICT --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php