From: Moon's Father (yueliangdao0608gmail.com)
Date: Thu Oct 30 2008 - 20:21:14 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I think Claudio Nanni 's suggestion is the best!

On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni <claudio.nannigmail.com>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 <supportobantec.net>
>
> > 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=claudio.nannigmail.com
> >
> >
>

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]