Yeah, I'm agree with michael. For migration of DB from one major version
to another, must use the below approach.
by the using mysqlupgrade, might be we can loss some data.
regards,
Nilnandan
Michael Dykman wrote:
> There are binary differences between v4.x and 5.x (5.1.x
> recommended).. The cleanest approach would be to do mysqldump on the
> old database and inject that into your new server.
>
> - michael dykman
>
> On Tue, Jun 29, 2010 at 4:04 PM, Grant Peel <gpeel@stripped> wrote:
>
>> nilnandan,
>>
>> I meant to say Mysqlupgrade :-)
>>
>> Further, I can use the old mysql tables, (the mysql gant tables, user/passwd/host
> tables etc) and the mysqlupgrade will update them as necessary?
>>
>> -Grant
>>
>> ----- Original Message -----
>> From: Nilnandan Joshi
>> To: Grant Peel
>> Cc: mysql@stripped
>> Sent: Tuesday, June 29, 2010 4:00 AM
>> Subject: Re: Updating from 4 to 5
>>
>>
>> Grant,
>>
>> I think, you should run mysqlupgrade after copying old data in new servers.
>>
>>
>> Regards,
>> nilnandan
>>
>>
>> Grant Peel wrote:
>> Hi all,
>>
>> I am about to move from FreeBSD 6 to FreeBSD 8. With that, the mysql server
> version will be changed from 4 to 5.
>>
>> I am assuming I can load all the users tables, and the mysql database (grant
> tables and all) to the new server, then run mysqlupdate, and everything that needs to be
> updated will be.
>>
>> Any comments?
>>
>> -Grant
>>
>>
>
>
>
>
