Using the sql:
alter table foo add index dex( keycol1, keycol2, keycol3 );
causes a Error 1030 with the annotation "table handler error 12". The particular table
involved has about 150000 entries, contains 10 or so varchar() fields with a record
size of O(500) bytes. The table is declared to be a BDB table.
If I dump the table with mysqldump, modify the declaration to include the index,
and then attept to reload, all goes well for a while, then everything dies with
multiple Error 2002 reports.
If I use the normal default table type (ISAM), I can load the respcified version
of the table with the indexes without problem.
I found no documentation on the reported errors and their potential cause. I did find
find one posting the cited these errors and suggested setting SQL_BIG_TABLES, but it
had no apparent impact.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
