After many headaches, rantings, and emails, i have FINALLY figured out how to get 64 indexes out of MySQL tables.
There are 3 changes you need to make to the source code. in file "mysql_priv.h" change the line: typedef ulong key_map to: typedef ulonglong key_map in file "include/myisam.h" change : #define MI_MAX_KEY 32 to : #define MI_MAX_KEY 64 in file "include/unireg.h" change : #define MAX_KEY 32 to : #define MAX_KEY 64 then recompile mysqld. I think its a sad situation that i could find numerous references to using 64 keys, none more specific than: "you need to change some things in the source code" or "you need to change some things in myisam.h and unireg.h, and some other things" regards sean peters [EMAIL PROTECTED] --------------------------------------------------------------------- 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