--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
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?
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/