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
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
