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] > >
