From owner-freebsd-isp@FreeBSD.ORG Fri Aug 19 18:20:23 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 A5FF616A41F for ; Fri, 19 Aug 2005 18:20:23 +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 4BFAE43D45 for ; Fri, 19 Aug 2005 18:20:23 +0000 (GMT) (envelope-from ruben@bloemgarten.demon.nl) Received: from axelds.demon.nl ([83.160.138.74]:58278 helo=abubbletprpdda) by post-24.mail.nl.demon.net with esmtp (Exim 4.51) id 1E6BTa-000Fyt-6Z; Fri, 19 Aug 2005 18:20:22 +0000 From: "Ruben Bloemgarten" To: "'James Ryan'" Date: Fri, 19 Aug 2005 20:19:26 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <43061888.7040408@jpri.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-index: AcWk5IKRrIR3Vx1CSvekSsZcMRDriQABGhXw Message-Id: <20050819182023.4BFAE43D45@mx1.FreeBSD.org> Cc: freebsd-isp@freebsd.org 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:20:23 -0000 Hi James,=20 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. Regards,=20 Ruben=20 -----Original Message----- From: James Ryan [mailto:james@jpri.com]=20 Sent: August 19, 2005 7:36 PM To: ruben@bloemgarten.demon.nl Cc: freebsd-isp@freebsd.org Subject: Re: migration from mysql 3.2.23 to 4.1.13 > I need to migrate a set of databases from a FBSD 5.2.1 /Mysql 3.2.23 server > to a FBSD 5.4 / mysql 4.1.13 machine. Now, I=92m aware that this is = not a FBSD > issue but I was hoping that someone on this list might have dealt with issue > before. Don't see why you couldn't use mysqldump... --=20 James Ryan Lead Developer, Systems Administrator Infinity Pro Sports http://www.infinityprosports.com --=20 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 --=20 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 =20 --=20 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 =20