From owner-freebsd-isp@FreeBSD.ORG Fri Aug 19 17:34:48 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 3D79016A41F for ; Fri, 19 Aug 2005 17:34:48 +0000 (GMT) (envelope-from volfman@keystreams.com) Received: from mailbox.keystreams.com (mailbox.keystreams.com [207.158.28.37]) by mx1.FreeBSD.org (Postfix) with ESMTP id C837243D48 for ; Fri, 19 Aug 2005 17:34:45 +0000 (GMT) (envelope-from volfman@keystreams.com) Received: (qmail 23254 invoked by uid 1012); 19 Aug 2005 10:33:16 -0700 Received: from 10.8.0.6 by mail.keystreams.com (envelope-from , uid 1009) with qmail-scanner-1.25-st-qms (clamdscan: 0.86.2/1001. spamassassin: 3.0.4. perlscan: 1.25-st-qms. Clear:RC:1(10.8.0.6):. Processed in 0.081732 secs); 19 Aug 2005 17:33:16 -0000 X-Antivirus-Keystreams-Mail-From: volfman@keystreams.com via mail.keystreams.com X-Antivirus-Keystreams: 1.25-st-qms (Clear:RC:1(10.8.0.6):. Processed in 0.081732 secs Process 23248) Received: from unknown (HELO ?10.8.0.6?) (volfman@keystreams.com@10.8.0.6) by mailbox.keystreams.com with AES256-SHA encrypted SMTP; 19 Aug 2005 10:33:16 -0700 Message-ID: <43061834.2090105@keystreams.com> Date: Fri, 19 Aug 2005 10:34:44 -0700 From: Roman Volf User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: ruben@bloemgarten.demon.nl References: <20050819165925.E1C0F43D67@mx1.FreeBSD.org> In-Reply-To: <20050819165925.E1C0F43D67@mx1.FreeBSD.org> Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 8bit 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 List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Aug 2005 17:34:48 -0000 Ruben Bloemgarten wrote: >Hi all, > > > >I need some help with a database migration and was hoping someone could give >me a tip or two. > > > >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’m aware that this is not a FBSD >issue but I was hoping that someone on this list might have dealt with issue >before. > > > >Thanks, > > > >Ruben > > > > Have you read http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html and http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html . I've used these and they helped tremendously upgrading to 4.1. -- Roman Volf Keystreams Internet Solutions volfman@keystreams.com