From: Dan Nelson
Date: February 22 2008 7:36pm
Subject: Re: Migrating form 3.23.49 to 5.0.32
List-Archive: http://lists.mysql.com/mysql/211474
Message-Id: <20080222193636.GB3328@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 22), Ed Curtis said:
> I'm doing the above migration as mentioned in the subject line. I figured I 
> would use the MySQL Migration Toolkit to help it along but it won't let me 
> connect to my 3.23.49 server. Is there any other way to migrate all my data 
> easily.

Basically make sure all your tables are in MyISAM format (i.e. upgrade
any ISAM ones), copy the raw table files to the 5.0 server, and run
mysql_upgrade.

The following urls have more detail, including incompatible changes
that you should be aware of:

http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

-- 
	Dan Nelson
	dnelson@stripped