--- "Dennis P. Nikolaenko" <[EMAIL PROTECTED]> 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/
