PHWinfo - Afficher un message - Upgrading Data From 4.x to 5.x On Windows

11/04/2008, 15h38

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

11/04/2008, 15h38	#8
Richard Messages: n/a Hébergeur:	Re: Upgrading Data From 4.x to 5.x On Windows "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.