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