Re: [RCU] How to update mysql.initial.sql

Stephen Liu wrote:

Hi folks,

Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql

Now I need to correct it without success;

$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists

Please advise how to force run the command. Or is there any other way? TIA

Do something like this

mysql -u roundcube -p roundcube

show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch