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 > -- - michael dykman - mdyk...@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=arch...@jab.org
