List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 22 2008 7:36pm
Subject:Re: Migrating form 3.23.49 to 5.0.32
View as plain text  
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
Thread
Migrating form 3.23.49 to 5.0.32Ed Curtis22 Feb
  • Re: Migrating form 3.23.49 to 5.0.32Wm Mussatto22 Feb
  • Re: Migrating form 3.23.49 to 5.0.32Dan Nelson22 Feb