Date: Fri, 19 Aug 2005 20:46:14 +0200 From: "Ruben Bloemgarten" <ruben@bloemgarten.demon.nl> To: <mario@schmut.com> Cc: freebsd-isp@freebsd.org, james@jpri.com Subject: RE: migration from mysql 3.2.23 to 4.1.13 Message-ID: <20050819184711.8A86C43D53@mx1.FreeBSD.org> In-Reply-To: <49542.192.168.23.8.1124476640.squirrel@mail.schmut.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Mario, The dump was done on 3.23. I'll give 4.1 a try on that machine, sounds like a nice hack though,using mysqldump 4.1 on a 3.23 database. Thanks for the tip. Ruben -----Original Message----- From: mario [mailto:mario@schmut.com] Sent: August 19, 2005 8:37 PM To: ruben@bloemgarten.demon.nl Cc: james@jpri.com; freebsd-isp@freebsd.org Subject: RE: migration from mysql 3.2.23 to 4.1.13 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;> -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 08/18/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 08/18/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 08/18/2005
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050819184711.8A86C43D53>