Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL database problem

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

  1. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    8
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    8
    cPanel Access Level:
    Root Administrator
    Does anyone know what could be the problem here?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,472
    Likes Received:
    421
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    8
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,472
    Likes Received:
    421
    Trophy Points:
    583
    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/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. mehnihma

    mehnihma Well-Known Member

    Joined:
    Dec 15, 2012
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    No it is not there
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,472
    Likes Received:
    421
    Trophy Points:
    583
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. mehnihma

    mehnihma Well-Known Member

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

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. musioc

    musioc Well-Known Member

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

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice