SQL updates

[jan.gestre]

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

[jan.gestre]

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

[jrmy]

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.