-----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----- _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"