Jerry Stuckle wrote:
> Steve wrote:
>> 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
>>
>
> Why not just change the path to the data files? It's just an entry in
> the my.ini file.
>
> Be sure to stop/start MySQL. And it would be a good idea to back up the
> databases using 4.1 before converting to 5.1.
>
Well, it would be preferable to have the data under the \MySQL Server 5.1\data folder instead of having to point back to the 4.1
directory and leave that whole directory there.

I'm amazed there isn't some sort of import or upgrade utility for a case like this.

Steve