Upgrading RoundCube Help

[CarlosinFL]

I am upgrading my Linux servers version of RoundCube this evening at 6pm. I have followed the Wiki:

Howto_Upgrade ? Roundcube Webmail

1. Copy my old RC directory:

Code: [Select]

cp -r /var/www/html/roundcube /var/www/html/roundcube_old
2. I backed up my MySQL database as suggested using 'sqldump'

Code: [Select]

mysqldump -u roundcube -p webmail > /var/backup/mysql/webmail.dump
3. I re-did my new v0.3.1 main.inc.php and db.inc.php from scratch using my old v0.2.1 configs as references.

4. Database Setup? This is where I am lost / confused. I am suppose to go to the 'SQL' directory and look for 'mysql.update.sql' since I am using MySQL 5.

What exactly am I suppose to do? Run what command against the 'mysql.update.sql' file? The Wiki is vague? I appears to be a .sql file and I don't know what I should do with it. Can someone please help and explain the process?

[alec]

Use mysql client software, phpmyadmin or mysql command.

[CarlosinFL]

Use mysql client software, phpmyadmin or mysql command.

Thanks for info.

So I login into MySQL via command line as my RC user or do I need to execute a MySQL command from the bash shell outside of MySQL? I am sorry I don't use MySQL enough.

[CarlosinFL]

I ran the file as suggested via MySQL and got the following error:

Code: [Select]

[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 my upgrade fail? Did I do something wrong? Obviously my config files are from v0.3.1 but is my MySQL database still outdated?

Should I have had MySQL running? I am guessing so since the .sql file needs to connect to MySQL and update the tables from 0.2.1 > 0.3.1.

Please help!