Tani Hosokawa writes:
> Hmm... So I can't use a mix of table types?
>
Hi,
Actually you should be able to. The problem is that MyISAM is very new
and needs some testing still. With option --default-table-type=isam
you can change 3.23.x to be like 3.22.x is, but you can still use many
features included in 3.23 which can not be found from 3.22. (Heap tables,
procedure analyse(), etc.)
Could you send us (you can send it directly to me) a mysqldump from
any table where you got this kind of error message, if you have them
as old isam type left still? It would be nice to have at least some of
the data (you can use option -w with mysqldump to restrict the
output). If the dump becomes very big, please zip it and ftp it to
www.mysql.com/pub/mysql/Incoming with some file name and drop me a
mail about it. Thank you.
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
> On Sun, 3 Oct 1999, Jani Tolonen wrote:
>
> > Tani Hosokawa writes:
> > > This is my table format... when I upgraded, I got errors telling my that
I
> > > had in invalid key file, and that I should try to repair it. isamchk
> > > didn't report any errors, and when I converted the database formats to
the
> > > new MyISAM format everything worked.
> >
> > Hello Tani,
> >
> > Please try starting mysqld with option --default-table-type=isam,
> > if you are using version 3.23 of MySQL with ISAM type (the old
> > table type) and get errors like the one above.
> >
> > Regards,
> >
> > - Jani
> >
> > --
> > +-------------------------------------------------------------+
> > | TcX ____ __ _____ _____ ___ |
> > | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
> > | /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
> > | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
> > | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
> > | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> > | /*/ \*\ Developers Team |
> > +-------------------------------------------------------------+
> >
>
> ---
> tani hosokawa
> river styx internet
>
