Stephen Liu wrote: > --- "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 > You have got all the required tables in "roundcube" database. Why do you need to "force" mysql.initial.sql?
-- Regards, Dennis P. Nikolaenko _______________________________________________ List info: http://lists.roundcube.net/users/
