+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: SQL database exist Cannot add new database ? (/thread-2729.html)
SQL database exist Cannot add new database ? - Adel - 03-14-2008 06:07 AM
Hello
when i try to add new database to a user i got this message:
"database exist Cannot add new database"
the only thing i did was i uninstalled ispcp because of some
problems and reinstalled it again.
but when i click on sql databases for this user i can't see
any of the databases that supposetly was added before
in the old installation.
I tried the search and i couldn't find anything , also i hope i am in
the right section of the forum.
any help will be appreciated
RE: SQL database exist Cannot add new database ? - Zothos - 03-14-2008 06:54 AM
delete them from your mysql manually and then add them via ispcp. then revert your backup of the mysql databases (not the ispcp db and mysql db)
RE: SQL database exist Cannot add new database ? - Adel - 03-14-2008 08:05 AM
Zothos Wrote:delete them from your mysql manually and then add them via ispcp. then revert your backup of the mysql databases (not the ispcp db and mysql db)
Hi Zothos
Thanks for fast reply.
I am not very advance in linux but i can write some code, i know
how to get in mysql but ineed code on how to delete them.
Thanks
RE: SQL database exist Cannot add new database ? - Cube - 03-14-2008 08:27 AM
There's something called PHPMyAdmin
.
RE: SQL database exist Cannot add new database ? - sci2tech - 03-14-2008 08:39 AM
Query:
drop database x;
or for debian:
rm -r /var/lib/mysql/x
where x is database name
RE: SQL database exist Cannot add new database ? - Adel - 03-14-2008 10:36 AM
Thanks to both of you for your help.
to answer Cube i know PHPMyAdmin and when i tried it , it says : no databases.
also thanks to sci2tech for your help i did and that was an easy solution.
Thanks to both of you again.