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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
