Date: Fri, 19 Aug 2005 11:37:20 -0700 (PDT) From: mario <mario@schmut.com> To: <ruben@bloemgarten.demon.nl> Cc: freebsd-isp@freebsd.org, james@jpri.com Subject: RE: migration from mysql 3.2.23 to 4.1.13 Message-ID: <49542.192.168.23.8.1124476640.squirrel@mail.schmut.com> In-Reply-To: <20050819182023.4BFAE43D45@mx1.FreeBSD.org> References: <43061888.7040408@jpri.com> <20050819182023.4BFAE43D45@mx1.FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
So, Ruben Bloemgarten wrote: > Hi James, > > That was the first thing I tried, unfortunately that does not work as > the way 3.23 deals with ISAM is different to 4.1 and so it spits out > errors when it runs into unrecognizable syntax. If you have managed to > use mysqldump for a migration I would very much appreciate hearing about > it as it would simplify things conisderably. was this using mysldump 3.23 or 4.1? they produce different results and i found one to work and the other not. i don't remember which did what but just try the version you haven't yet. then there is also http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html and then http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html looking at the docs, it seems, you need to do a bit more than just a dump. hope this helps. i remember going from 4.0 to 4.1 was already fun. mario;>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49542.192.168.23.8.1124476640.squirrel>