List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:October 30 2008 3:32pm
Subject:Re: moving from 3.23.58 to 5.0.45
View as plain text  
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
comparisons occur.  I've had to add 'RTRIM' when comparing CHAR type with
strings from the web which are not space extended, but that may just be my
vesion of DBD::mysql.    Good luck.
On Thu, October 30, 2008 05:29, Claudio Nanni 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 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 have problems try with 4.1 or 4.0 as a midway step.
>
> At this very moment I can't tell you if you will have problems with the
> 'big' jump, but you should test with a smaller set of data(if your DB is
> huge)
> and after that decide if do the direct jump or use a step in the middle.
>
> Here's the idea:
>
> [3.23.58]--->[5.0.45]
> OR
> [3.23.58]--->[4.x]--->[5.0.45]
> OR
> [3.23.58]--->[4.0.x]--->[4.1.x]--->[5.0.45]
>
>
> Commands to use:
>
> [3.23.58]# mysqldump --all-databases   >dump.sql
>
> will do the job and
>
> [5.0.45] mysql> source dump.sql
>
> will complete the opera!
>
> remember that after that also the grant tables will be replaced from the
> original DB(3.23.58)
>
> hope it helps
>
>
> Claudio
>
>
>
>
> 2008/10/30 Obantec Support <support@stripped>
>
>> 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/mysql?unsub=1
>>
>>
>


Thread
moving from 3.23.58 to 5.0.45Obantec Support30 Oct
  • Re: moving from 3.23.58 to 5.0.45Rob Wultsch30 Oct
  • Re: moving from 3.23.58 to 5.0.45Claudio Nanni30 Oct
    • Re: moving from 3.23.58 to 5.0.45Wm Mussatto30 Oct
    • Re: moving from 3.23.58 to 5.0.45Moon's Father31 Oct