updating mysql database

[Matthew Seaman]

-----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-----