Use mysqldump on the old version and import the data into new version in my opinion.
On Fri, Aug 22, 2008 at 1:29 AM, Andy Shellam <[EMAIL PROTECTED]>wrote: > 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] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
