Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
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
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why do you need to "force" mysql.initial.sql?