Re: Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Nunzio Daveri
.. Nunzio From: Keith Murphy To: Nunzio Daveri Cc: mysql@lists.mysql.com Sent: Mon, August 16, 2010 11:47:39 AM Subject: Re: Is upgrading from 4.X to 5.X really that easy? I would really recommend that you have a second server set up running MySQL 5.0. Otherwise the com

Re: Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Keith Murphy
__ > From: Keith Murphy > To: Nunzio Daveri > Sent: Mon, August 16, 2010 9:42:07 AM > Subject: Re: Is upgrading from 4.X to 5.X really that easy? > > No, that would be a huge mistake. There are subtle differences between the > two > versions. For example, check up on D

Re: Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Nunzio Daveri
l the data is in MyISAM, zero InnoDB :-) Thanks again for the advice :-) Nunzio From: Keith Murphy To: Nunzio Daveri Sent: Mon, August 16, 2010 9:42:07 AM Subject: Re: Is upgrading from 4.X to 5.X really that easy? No, that would be a huge mistake. Ther

Re: Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Keith Murphy
MySQL rightly says you should dump and reload. As William said, you should read the release notes for every release between your current release and the target release. I have done this several times. I am currently planning a migration from 4.1.22 to 5.1.49 with a brief stop at 5.0 along the way.

Re: Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Wm Mussatto
On Mon, August 16, 2010 07:26, Nunzio Daveri wrote: > Hi all, I was reading a few of the notes on this forum from a few months > back > and it seems that ONE WAY of upgrading from 4.x to 5.X with MyISAM only > databases is to copy the actual data folder from the 4.X version to a temp > place, the

Is upgrading from 4.X to 5.X really that easy?

2010-08-16 Thread Nunzio Daveri
Hi all, I was reading a few of the notes on this forum from a few months back and it seems that ONE WAY of upgrading from 4.x to 5.X with MyISAM only databases is to copy the actual data folder from the 4.X version to a temp place, then remove 4.x from the OS, install 5.X and then just put the 4