Updating from 4 to 5

------=_NextPart_000_00F0_01CB16E8.1C8E9080
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_00F0_01CB16E8.1C8E9080--

Re: Updating from 4 to 5

--------------020003090803060404010200
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>

--------------020003090803060404010200--

Re: Updating from 4 to 5

------=_NextPart_000_0048_01CB17A4.BD49B1F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 -----=20
From: Nilnandan Joshi=20
To: Grant Peel=20
Cc: mysql@lists.mysql.com=20
Sent: Tuesday, June 29, 2010 4:00 AM
Subject: Re: Updating from 4 to 5


Grant,=20

I think, you should run mysqlupgrade after copying old data in new =
servers.


Regards,=20
nilnandan


Grant Peel wrote:=20
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

------=_NextPart_000_0048_01CB17A4.BD49B1F0--

Re: Updating from 4 to 5

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 wrote:
> nilnandan,
>
> I meant to say Mysqlupgrade :-)
>
> Further, I can use the old mysql tables, (the mysql gant tables, user/pas=
swd/host tables etc) and the mysqlupgrade will update them as necessary?
>
> -Grant
>
> ----- Original Message -----
> =A0From: Nilnandan Joshi
> =A0To: Grant Peel
> =A0Cc: mysql@lists.mysql.com
> =A0Sent: Tuesday, June 29, 2010 4:00 AM
> =A0Subject: Re: Updating from 4 to 5
>
>
> =A0Grant,
>
> =A0I think, you should run mysqlupgrade after copying old data in new ser=
vers.
>
>
> =A0Regards,
> =A0nilnandan
>
>
> =A0Grant Peel wrote:
> Hi all,
>
> I am about to move from FreeBSD 6 to FreeBSD 8. With that, the mysql serv=
er version will be changed from 4 to 5.
>
> I am assuming I can load all the users tables, and the mysql database (gr=
ant tables and all) to the new server, then run mysqlupdate, and everything=
that needs to be updated will be.
>
> Any comments?
>
> -Grant
>



--=20
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Updating from 4 to 5

--------------070008070106020004090306
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 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@lists.mysql.com
>> 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
>>
>>
>
>
>
>

--------------070008070106020004090306--