Roundcube Community Forum

SVN Releases => SVN Discussion => Topic started by: jan.gestre on August 10, 2006, 09:29:31 PM

Title: SQL updates
Post by: jan.gestre on August 10, 2006, 09:29:31 PM

i'm now using svn 307, i noticed that since i've upgraded to beta2 there is a SQL database update, everytime i do svn checkout, i just copy where i downloaded trunk to my document root. my question is do i have to do something like this? :

# mysql roundcubemail < SQL/mysql.initial.sql

or just copying it would be enough? if i do the procedure above, what will happen to the currently installed database, i mean would it affect any mails in the inbox?

TIA

Title: Re: SQL updates
Post by: jan.gestre on August 10, 2006, 11:00:44 PM

i tried this command but it gave this error:

% mysql -u root -p roundcubemail < SQL/mysql.initial.sql
Enter password:********
ERROR 1050 (42S01) at line 11: Table 'cache' already exists

how do i update the current roundcubemail database? what is/are commands?

TIA

Title: Re: SQL updates
Post by: jrmy on August 11, 2006, 10:59:40 AM

You should only need to run the appropriate section of mysql.udpate.sql file.

It contains the update SQL statements to update from different versions.