updating mysql database

2007-07-27 Thread Robert Huff
David Banning writes: 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? It is my understanding that you will have to dump (using the appropriate MySQL utilities) the

updating mysql database

2007-07-27 Thread David Banning
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? ___ freebsd-questions@freebsd.org mailing list

Re: updating mysql database

2007-07-27 Thread Gabor Kovesdan
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

Re: updating mysql database

2007-07-27 Thread Hakan K
Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any other software beta release. MySQL generally recommends that you dump and reload your tables from any previous version to upgrade to 5.2. Troy http://primoris.com On

Re: updating mysql database

2007-07-27 Thread 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