From owner-freebsd-questions@FreeBSD.ORG Fri Jul 27 20:49:42 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 83C0316A417; Fri, 27 Jul 2007 20:49:42 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id C6C0B13C48E; Fri, 27 Jul 2007 20:49:41 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1]) by smtp.infracaninophile.co.uk (8.14.1/8.14.1) with ESMTP id l6RKnPWM028473; Fri, 27 Jul 2007 21:49:26 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: smtp.infracaninophile.co.uk from=m.seaman@infracaninophile.co.uk; sender-id=permerror; spf=permerror X-SenderID: Sendmail Sender-ID Filter v0.2.14 smtp.infracaninophile.co.uk l6RKnPWM028473 Message-ID: <46AA5A55.1070107@infracaninophile.co.uk> Date: Fri, 27 Jul 2007 21:49:25 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.5 (X11/20070721) MIME-Version: 1.0 To: Gabor Kovesdan References: <20070727133354.GA4021@skytracker.ca> <46AA168A.9080306@FreeBSD.org> In-Reply-To: <46AA168A.9080306@FreeBSD.org> X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0 (smtp.infracaninophile.co.uk [IPv6:::1]); Fri, 27 Jul 2007 21:49:36 +0100 (BST) X-Virus-Scanned: ClamAV 0.91.1/3784/Fri Jul 27 18:35:18 2007 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=AWL,BAYES_00, DKIM_POLICY_SIGNSOME,DKIM_POLICY_TESTING,DK_POLICY_SIGNSOME,NO_RELAYS autolearn=ham version=3.2.1 X-Spam-Checker-Version: SpamAssassin 3.2.1 (2007-05-02) on happy-idiot-talk.infracaninophile.co.uk Cc: questions@freebsd.org, David Banning 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 20:49:42 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Gabor Kovesdan wrote: > 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. > Recent versions of mysql come with a handy utility called 'mysql_upgrade' -- it basically does what you need in changing the internal format of the tables so that recent MySQL can use them. Plus it should update the mysql.* tables so they can grok all the new GRANTS and stuff. Cheers, Matthew - -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqlpU8Mjk52CukIwRCFxYAJ9mG9sf0u1BJ6HcIcEKlSsVOeSqhgCeLpx9 5310RRJSEHyf9Pd5M4dLJ2w= =6fmY -----END PGP SIGNATURE-----