"Steve" <racquetballer@hotmail.com> wrote in message
news:ReGdnaTKBLubP2TanZ2dnUVZ_oCvnZ2d@comcast.com. ..
>I just upgraded from 4.1.22 to 5.1 on my Windows dev machine.
>Everything installed fine with the new version, and I can connect
>without a problem. The question I have is about my data. Since I'm
>on Windoze and using the .msi installer, the new version - and the
>data - is installed in a different path:
>
> old - C:\Program Files\MySQL\MySQL Server 4.1\data
> new - C:\Program Files\MySQL\MySQL Server 5.1\data
>
> There seems to be no automatic way to get the data from 4.1 and put
> it in 5.1. How can I do that? I looked in the manual, and I don't
> see anything that addresses this. Can I just copy the directories
> from the 4.1 \data directory, or is there a tool to use to do this?
>
> Thanks.
>
> Steve

I had some problems when going from 4 to 5.
These included passwords not working anymore, and differences in NULL
value handling.

I used a data dump / backup to get the data from the old to the new
version.

I suggest you do a parallel install and test rigorously before going
into production.

Richard.