Current time: 12-25-2024, 03:45 PM Hello There, Guest! (LoginRegister)


Post Reply 
SQL database exist Cannot add new database ?
Author Message
Adel Offline
Junior Member
*

Posts: 38
Joined: Feb 2008
Reputation: 0
Post: #1
SQL database exist Cannot add new database ?
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
03-14-2008 06:07 AM
Find all posts by this user Quote this message in a reply
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #2
RE: SQL database exist Cannot add new database ?
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)
03-14-2008 06:54 AM
Find all posts by this user Quote this message in a reply
Adel Offline
Junior Member
*

Posts: 38
Joined: Feb 2008
Reputation: 0
Post: #3
RE: SQL database exist Cannot add new database ?
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
03-14-2008 08:05 AM
Find all posts by this user Quote this message in a reply
Cube Offline
Member
***

Posts: 740
Joined: Apr 2007
Reputation: 9
Post: #4
RE: SQL database exist Cannot add new database ?
There's something called PHPMyAdmin Tongue.
03-14-2008 08:27 AM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #5
RE: SQL database exist Cannot add new database ?
Query:
drop database x;
or for debian:
rm -r /var/lib/mysql/x
where x is database name
(This post was last modified: 03-14-2008 08:41 AM by sci2tech.)
03-14-2008 08:39 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Adel Offline
Junior Member
*

Posts: 38
Joined: Feb 2008
Reputation: 0
Post: #6
RE: SQL database exist Cannot add new database ?
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.
(This post was last modified: 03-14-2008 10:39 AM by Adel.)
03-14-2008 10:36 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 3 Guest(s)