Re: Updating from 4 to 5

2010-06-30 Thread Nilnandan Joshi
asswd/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

Re: Updating from 4 to 5

2010-06-29 Thread Michael Dykman
@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, >

Re: Updating from 4 to 5

2010-06-29 Thread Grant Peel
@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

Re: Updating from 4 to 5

2010-06-29 Thread Nilnandan Joshi
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, an

Updating from 4 to 5

2010-06-28 Thread Grant Peel
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