On Thu, Jan 21, 2010 at 1:07 PM, chasd chasd@silveroaks.com wrote:
Apply the SQL file to your existing database : mysql -u roundcube -p webmail < mysql.update.sql
If that borks it up, you can drop that database and load in your backup from the dump file and try again, or dump the borked data and compare it to your backup data.
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. _______________________________________________ List info: http://lists.roundcube.net/users/
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.
On Thu, Jan 21, 2010 at 6:34 PM, chasd chasd@silveroaks.com wrote:
Does that user have grant rights to drop indexes ? You might want to run that command under the MySQL admin user.
The user <roundcube> has full permissions on that database but just to be sure, I ran the command as <root> and got the same error:
[root@ideweb1 SQL]# mysql -u root -p webmail < mysql.update.sql Enter password: ERROR 1091 (42000) at line 6: Can't DROP 'idx'; check that column/key exists _______________________________________________ List info: http://lists.roundcube.net/users/
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
You shouldn't run all commands from this file, just read the comments in it.
On Fri, Jan 22, 2010 at 2:07 AM, A.L.E.C alec@alec.pl wrote:
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
You shouldn't run all commands from this file, just read the comments in it.
OK, I think I understand now. So when I open the 'mysql.update.sql' file using VIM, do I delete out the sections that do not apply to me?
Where is the 'upgrade from 0.2.1 > 0.3.1 in the file? I only see "-- Updates from version 0.2-beta (InnoDB only)" and then it skips to "-- Updates from version 0.3-stable".
Which section do I keep in this file? _______________________________________________ List info: http://lists.roundcube.net/users/
-
A.L.E.C -
Carlos Williams -
chasd