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 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 <[EMAIL PROTECTED]> > > > 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] > > > > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
