--- "Dennis P. Nikolaenko" <[EMAIL PROTECTED]> wrote: > 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?
Because I can't start roundcube on browser. http://domain.com/mail File 404 Not Found. I'm now investing the cause of problem. I adjust the name of "roundcube". Before some in "roundcude", "roundcubemail", "roundcubemail;-0.1". The new path of mysql.initial.sql should be on /var/www/roundcube/SQL/mysql.initial.sql Thanks B.R. Stephen L Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
