From: Michael Dykman Date: June 29 2010 8:17pm Subject: Re: Updating from 4 to 5 List-Archive: http://lists.mysql.com/mysql/222034 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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@stripped > =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@stripped May the Source be with you.