List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:October 31 2008 1:21am
Subject:Re: moving from 3.23.58 to 5.0.45
View as plain text  
I think Claudio Nanni 's suggestion is the best!

On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni <claudio.nanni@stripped>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
> >
> >
>



-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

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