Update of RounCube SQL

[misterm]

Hello with all

I would like to carry out an update of RoundCube for the base of gives MYSQL

mysql.update.sql

How to make under SSH, the command mysql

Good day MM:confused:

[Hans]

I i understand you well, you want the code to perform an update from a previous version. Here are the possibilities for MySQL:

For MySQL 4.0.x for a first fresh install:
------------------------------------------
mysql roundcubemail < SQL/mysql.initial.sql

For MySQL 4.0.x for an update from the previous version:
--------------------------------------------------------
mysql roundcubemail < SQL/mysql.update.sql


For MySQL 4.1.x/5.x for a first fresh install:
----------------------------------------------
mysql roundcubemail < SQL/mysql5.initial.sql


For MySQL 4.1.x/5.x for an update from the previous version:
------------------------------------------------------------
mysql roundcubemail < SQL/mysql.update.sql

The SQL files can be found within the SQL directory which comes with RoundCube.
Read the INSTALL file which comes with RoundCube for more information.

Of course you also can use phpMyAdmin to do this job.

[misterm]

Hello Hans, in any case thank you, but doesn't your solution function?

Because j' have an error at the time of connection

You do not have another solution, of the kind, to make a backup, on the tables for example, is to introduce them into the new version?

Thank you Hans

MM ;):confused:

[misterm]

Hans, you is on that this file which is " mysql5.update" this finds well in repertory SQL, because when I list this same repertory, it this does not find…

-rw-r--r-- 1 web67_XXXXXX web67 7608 2007-09-19 08:55 mssql.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 4214 2008-06-12 19:46 mysql5.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 3812 2008-06-12 19:46 mysql.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 869 2008-06-12 19:46 mysql.update.sql
-rw-r--r-- 1 web67_XXXXXX web67 5228 2008-06-12 19:46 postgres.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 1195 2008-06-12 19:46 postgres.update.sql
-rw-r--r-- 1 web67_XXXXXX web67 3580 2008-06-12 19:46 sqlite.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 1018 2008-06-12 19:46 sqlite.update.sql

MM:eek::confused:;)

[Hans]

The right command should be:
mysql roundcubemail < SQL/mysql.update.sql

For further upgrade instructions, please have a look to the text file "UPGRADING" which comes with RoundCube.