Re: Updating from 4 to 5

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

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,

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 Michael Dykman
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

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