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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?46AA5A55.1070107>