Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 27 Jul 2007 21:49:25 +0100
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        Gabor Kovesdan <gabor@freebsd.org>
Cc:        questions@freebsd.org, David Banning <david+dated+1185975235.369212@skytracker.ca>
Subject:   Re: updating mysql database
Message-ID:  <46AA5A55.1070107@infracaninophile.co.uk>
In-Reply-To: <46AA168A.9080306@FreeBSD.org>
References:  <20070727133354.GA4021@skytracker.ca> <46AA168A.9080306@FreeBSD.org>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
-----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-----



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?46AA5A55.1070107>