Author Topic: SQL updates  (Read 4112 times)

Offline jan.gestre

  • Jr. Member
  • **
  • Posts: 51
SQL updates
« 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

Offline jan.gestre

  • Jr. Member
  • **
  • Posts: 51
Re: SQL updates
« Reply #1 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

Offline jrmy

  • Jr. Member
  • **
  • Posts: 48
Re: SQL updates
« Reply #2 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.