--- "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
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/