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.

MySQL database problem

Discussion in 'Database Discussions' started by mehnihma, Mar 26, 2013.

  1. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi

    I have strange database in mysql:

    baza__1364339824-77b9dbf4sql.bz2

    and I cannot see it in phpmyadmin or when I ssh to server, only I can see it in MySQL Databases in cpanel !?!

    How can I find it and delete it?

    Any ideas?
     
    #1 mehnihma, Mar 26, 2013
    Last edited: Mar 26, 2013
  2. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Does anyone know what could be the problem here?
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    The extension says its a compressed file I believe: .bz2

    What does the the size of it tell you there, I'm just curious.
    Is the "Delete Database" link showing to the right of this item?
     
  4. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    No there is no size.

    Yes there is a delete link but when I delete it it is back again
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    See if you can find that file: baza__1364339824-77b9dbf4sql.bz2 sitting in this directory:
    /var/lib/mysql/
     
  6. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    No it is not there
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might want to open a ticket to cPanel Technical Support. In your WHM, top right corner of any page is a small icon, clicking it opens a list of links, one of them shown is titled, Contact cPanel.
     
  8. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Ok I will

    Thanks
     
  9. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    What was the problem?
    Any solution?
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    In this particular case, the database was removed at some point in the past, but entries remained in the following files:

    Code:
    /var/cpanel/databases/dbindex.db
    /var/cpanel/databases/username.yaml
    Manually removing the entries for the orphaned database resolved this particular issue.

    Thank you.
     
Loading...

Share This Page