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. 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 --------------------------------------------------------------------- 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