I am upgrading my Linux servers version of RoundCube this evening at 6pm. I have followed the Wiki:
Howto_Upgrade ? Roundcube Webmail (http://trac.roundcube.net/wiki/Howto_Upgrade)
1. Copy my old RC directory:
cp -r /var/www/html/roundcube /var/www/html/roundcube_old
2. I backed up my MySQL database as suggested using 'sqldump'
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?
Use mysql client software, phpmyadmin or mysql command.
Quote from: alec;24746Use 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.
I ran the file as suggested via MySQL 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 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!