Upgrading Data From 4.x to 5.x On Windows

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

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

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

Steve wrote:
>
>
> 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
>

OK, if that's what you want. Personally, I put all of my data on a
completely different drive, and the directory doesn't have a release
associated with it.

But then I find it's always better to keep data and programs on separate
drives.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"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.

Richard wrote:
> "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.
>
>
>

The change in passwords was between 4.0 and 4.1. Did you read the
documentation on the changes?

I've performed several upgrades since 4.1 came out, and all of them went
smoothly.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

>> 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
>>
>
> OK, if that's what you want. Personally, I put all of my data on a
> completely different drive, and the directory doesn't have a release
> associated with it.
>
> But then I find it's always better to keep data and programs on separate
> drives.
>

Point taken. However, in this case, this is just a development machine for web development, not a production server, so I'm not
too concerned about this. But I think I will try moving it to my secondary hard drive just in case.

Thanks.

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:8oqdnYVlFsV_GmPanZ2dnUVZ_qXinZ2d@comcast.com. ..
> Richard wrote:
>> "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.
>>
>>
>>
>
> The change in passwords was between 4.0 and 4.1. Did you read the
> documentation on the changes?

Yes.
And still I had to solve the passwords problems. :)

Richard.