I was doing some mysql work for a WordPress database which required me to use the dbDelta function (more on that in another post) a number of times and after a while I found that the constant recreation of UNIQUE KEY indexes caused my db to run out of index resources, throwing me the following error:
WordPress database error: [Too many keys specified; max 64 keys allowed] ALTER TABLE x ADD UNIQUE KEY (`y`)
After getting the error I had to go and remove these duplicate indexes from my db and went looking for the indexes section inside my db table’s structure in PHPMyAdmin (there were 64 keys created and I didn’t really feel like writing a script to do the job – I know, pretty lazy).
To my surprise, I couldn’t find the indexes section in PHPMyAdmin for the world of me and I was stuck until I ran into this post by rackerhacker – he clarified that in PHPMyAdmin 3.x, the indexes section in a table’s structure view is hidden by default.
So, in order to get to a table’s indexes view you have to add the following line to your PHPMyAdmin configuration file:
$cfg['InitialSlidersState'] = 'open';