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 <[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] >> >> >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
