From owner-freebsd-isp@FreeBSD.ORG Fri Aug 19 18:47:11 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E8A0B16A41F for ; Fri, 19 Aug 2005 18:47:11 +0000 (GMT) (envelope-from ruben@bloemgarten.demon.nl) Received: from post-24.mail.nl.demon.net (post-24.mail.nl.demon.net [194.159.73.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8A86C43D53 for ; Fri, 19 Aug 2005 18:47:11 +0000 (GMT) (envelope-from ruben@bloemgarten.demon.nl) Received: from axelds.demon.nl ([83.160.138.74]:6055 helo=abubbletprpdda) by post-24.mail.nl.demon.net with esmtp (Exim 4.51) id 1E6BtW-000JGi-DN; Fri, 19 Aug 2005 18:47:10 +0000 From: "Ruben Bloemgarten" To: Date: Fri, 19 Aug 2005 20:46:14 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <49542.192.168.23.8.1124476640.squirrel@mail.schmut.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-index: AcWk7Q12pM+9TBUFRTegHYgy5WBMPAAAMn4w Message-Id: <20050819184711.8A86C43D53@mx1.FreeBSD.org> Cc: freebsd-isp@freebsd.org, james@jpri.com Subject: RE: migration from mysql 3.2.23 to 4.1.13 X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: ruben@bloemgarten.demon.nl List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Aug 2005 18:47:12 -0000 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