On 06/10/2007, Voytek Eymont <[EMAIL PROTECTED]> wrote: > > I have MySQL 3.x server and intend to migrate to Centos 4 MySQL 4.1; > > the docs suggests to upgrade 1st to ver.0 before going to ver.1+ > as far as I can tell, I can dump data OK form 3.x to 4.1 > the MySQL data is mainly php web contents data > > it it really necessary to do 3.x > 4.0 > 4.1 ? > > what character set should I use on 4.1, utf-8 ? > > anyhow, if anyone has any hints, much appreciate
Have you tried to google "how to upgrade mysql 3 to mysql 4?"? I found, for instance, the following link: http://mysqldatabaseadministration.blogspot.com/2005/10/upgrade-to-mysql5-1-upgrading-mysql3.html MySQL 4's installation process (at least on Debian) asks whether you want it to support the older character set for backward compatibility, so it should have this option. Also while you are at it - maybe you should consider MySQL 5, since 4 is going to be dropped from support some time not far away, and CentOS 5, since it should have much easier package management tools if for no other reason. --Amos -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
