The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[BUG] mySQL Databases undeletable

Discussion in 'General Discussion' started by cyon, Jul 28, 2003.

  1. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    16
    hi,

    one of the last updates (I guess to 7.2.1) renamed all mysql databases.
    if a user with a hyphaneted username (like 'user-name') created a database in the older cpanel, the database got the name 'username_xyz'.
    the update changed it into 'user-name_xyz', which appears logical, but now, the databases can't be dropped anymore in the users cpanel.

    the user get's the error: /usr/bin/mysqladmin: DROP DATABASE gc-lae_osc1 failed; error: 'Can't drop database 'gc-lae_osc1'. Database doesn't exist'

    The database exists, but it has the name 'gclae_osc1' and cpanel can't find it.

    Strangely enough cpanel shows the databasename 'gclae_osc1', but it tries to delete 'gc-lae_osc1'.

    anyone got the same problem?
    is there already a fix available?

    greetz, dave.

    cPanel.net Support Ticket Number: 19481
     
    #1 cyon, Jul 28, 2003
    Last edited: Jul 31, 2003
  2. cjg

    cjg Member

    Joined:
    Nov 20, 2001
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    You can go directly into the mysql data directory and do an rm -rf of the effected database.

    I am not sure if its a good idea to publicly post the exact location of the databases as this could be a security risk.

    The removal of the directory will drop the username and database from the affected cpanel account.

    It might be a good idea to use mysqldump -u root -p databasename > backup.sql so that if it is a live database you at least save the content of it to avoid any unhappy customers.

    cPanel.net Support Ticket Number:
     
  3. mmkassem

    mmkassem Well-Known Member

    Joined:
    Oct 21, 2002
    Messages:
    390
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Egypt
    Open a ticket from your WHM ..

    cPanel.net Support Ticket Number:
     
  4. cyon

    cyon Well-Known Member
    PartnerNOC

    Joined:
    Jan 15, 2003
    Messages:
    320
    Likes Received:
    0
    Trophy Points:
    16
    I've modified the path in this thread :)

    I know that I can delete them manually, but this will not solve the problem of my clients.
    I won't delete hundred of databases..

    cPanel.net Support Ticket Number: 19481
     
    #4 cyon, Jul 28, 2003
    Last edited: Jul 31, 2003
Loading...

Share This Page