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 <gp...@thenetnow.com> 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
