FYI the manual for 5.0 recommends upgrading to 4.1 first.
"As a general rule, we recommend that when upgrading from one release
series to another, you should go to the next series rather than
skipping a series. If you wish to upgrade from a release series
previous to MySQL 4.1, you should upgrade to each successive release
series in turn until you have reached MySQL 4.1, and then proceed with
the upgrade to MySQL 5.0. For example, if you currently are running
MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0
first before upgrading to 4.1."
It also says to run the "mysql_upgrade" program to convert your table
formats and grant tables. There have been plenty of changes as you'd
expect, including numerous incompatible changes to the SQL parser, so
make sure you read the following manual page first to see if your
applications are affected:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html.
If in any doubt, a dump from the old server and reload into the new
server would probably be a better upgrade method.
Andy
Quoting Nanu Kalmanovitz <[EMAIL PROTECTED]>:
Hi!
I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2,
MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67.
Is there any possibility to upgrade directly from MySQL 4.0.26 to
5.0.67, without upgrading first to the intermediate versions?
TIA
Nanu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
