From owner-freebsd-questions@FreeBSD.ORG Fri Jul 27 16:16:26 2007 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1955616A419 for ; Fri, 27 Jul 2007 16:16:26 +0000 (UTC) (envelope-from gabor@FreeBSD.org) Received: from server.t-hosting.hu (server.t-hosting.hu [217.20.133.7]) by mx1.freebsd.org (Postfix) with ESMTP id C1B9D13C467 for ; Fri, 27 Jul 2007 16:16:25 +0000 (UTC) (envelope-from gabor@FreeBSD.org) Received: from localhost (localhost [127.0.0.1]) by server.t-hosting.hu (Postfix) with ESMTP id 066829F3158; Fri, 27 Jul 2007 18:00:23 +0200 (CEST) X-Virus-Scanned: amavisd-new at t-hosting.hu Received: from server.t-hosting.hu ([127.0.0.1]) by localhost (server.t-hosting.hu [127.0.0.1]) (amavisd-new, port 10024) with LMTP id LeOvBKo6WYXA; Fri, 27 Jul 2007 18:00:18 +0200 (CEST) Received: from [192.168.2.186] (catv-5063f539.catv.broadband.hu [80.99.245.57]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by server.t-hosting.hu (Postfix) with ESMTP id 669869F314A; Fri, 27 Jul 2007 18:00:18 +0200 (CEST) Message-ID: <46AA168A.9080306@FreeBSD.org> Date: Fri, 27 Jul 2007 18:00:10 +0200 From: Gabor Kovesdan User-Agent: Thunderbird 2.0.0.5 (Windows/20070716) MIME-Version: 1.0 To: David Banning References: <20070727133354.GA4021@skytracker.ca> In-Reply-To: <20070727133354.GA4021@skytracker.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Cc: questions@freebsd.org Subject: Re: updating mysql database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 27 Jul 2007 16:16:26 -0000 David Banning escribió: > I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that > not all tables work. Is there a conversion to take the database from 4.1 to 5.1? > I think you only have to run REPAIR TABLE or OPTIMIZE TABLE on the broken tables. IIRC, the indexing changed between 4.X and 5.X versions. Regards, -- Gabor Kovesdan FreeBSD Volunteer EMAIL: gabor@FreeBSD.org .:|:. gabor@kovesdan.org WEB: http://people.FreeBSD.org/~gabor .:|:. http://kovesdan.org