mysql error 1069 Too many keys specified; max 64 keys allowed

Question

i am trying to run alter table command and i am getting the following error:

#1069 - Too many keys specified; max 64 keys allowed

any help will be highly appreciated

Answer 1

According to the mysql forums you must compile with

./configure --prefix=/usr/local/mysql --with-charset=cp1251 --enable-thread-safe-client --with-max-indexes=256

source: http://forums.mysql.com/read.php?22,53666,262189#msg-262189

unfortunately there does not appear to be a way to change after compiling