On Jan 21, 2010, at 4:19 PM, Carlos Williams wrote:
I ran the command as suggested and got the following error:
[root@ideweb1 SQL]# mysql -u roundcube -p webmail < mysql.update.sql Enter password: ERROR 1091 (42000) at line 6: Can't DROP 'idx'; check that column/ key exists
What does this mean? Did I do something wrong? Did I need to have MySQL stopped or running? I don't understand why I got this error.
Does that user have grant rights to drop indexes ? You might want to run that command under the MySQL admin user.