Re: moving from 3.23.58 to 5.0.45

2008-10-30 Thread Moon's Father
I think Claudio Nanni 's suggestion is the best! On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni <[EMAIL PROTECTED]>wrote: > Hi Mark, > > from my experience I can tell you that you can easily migrate. > > A quick and dirty way is to use the two(or more) different MySQL > installations > on same se

Re: moving from 3.23.58 to 5.0.45

2008-10-30 Thread Wm Mussatto
On thing that tripped me up when I did the same move was the change in LEFT JOIN syntax. It now joins to the LAST table in a list. This change actually happened half way through the 4.0x series. Doesn't effect data, but does effect queries. There MAY also be a difference on how string compariso

Re: moving from 3.23.58 to 5.0.45

2008-10-30 Thread Claudio Nanni
Hi Mark, from my experience I can tell you that you can easily migrate. A quick and dirty way is to use the two(or more) different MySQL installations on same server (or even different ones) and different ports of course. You dump the whole DB from the 3.23.58 and import it on the 5.0.45. If you

Re: moving from 3.23.58 to 5.0.45

2008-10-30 Thread Rob Wultsch
On Thu, Oct 30, 2008 at 5:16 AM, Obantec Support <[EMAIL PROTECTED]>wrote: > Hi > > are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 > moving from a Fedora Core3 to Centos5.2 server. > > Mark > > http://www.justfuckinggoogleit.com/?q=mysql+upgrade First result. -- Rob Wultsc

moving from 3.23.58 to 5.0.45

2008-10-30 Thread Obantec Support
Hi are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 moving from a Fedora Core3 to Centos5.2 server. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]