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!

Wrong DB count in cPanel

Discussion in 'Database Discussion' started by Havri, Oct 28, 2015.

  1. Havri

    Havri Well-Known Member

    Joined:
    Oct 28, 2013
    Messages:
    77
    Likes Received:
    17
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hello,

    I am encountering some issues with the cPanel DB Count in the cPanel interface. A user has only 2 DBs in cPanel, as shown in PHPMyAdmin and in the mysql information schema.

    In the directory /home/user/.cpanel/datastore/mysql-db-count, the number is correct (2, in this case), but in the /var/cpanel/datastore/user/ directory there are 2 files (mysql-db-count and mysql-db-usage). Both of these files contain incorrect info about the user's DB count.

    The file "mysql-db-count" contains only the character "7" and the "mysql-db-usage" contains some info about databases that probably existed, but don't exista anymore:

    user_qs: 0
    user_magento: 19926724
    user_chuck_norris: 0
    user_test: 0
    user_demo: 0
    user_ciberonix: 0
    user_work: 30573140

    I already ran /scripts/update_db_cache a few times but it didn't help.

    Can anyone help me get this fixed?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,161
    Likes Received:
    370
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    In that accounts cPanel > Databases section > MySQL Databases, do you see them listed there? If yes, you can delete them from there as well.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Havri

    Havri Well-Known Member

    Joined:
    Oct 28, 2013
    Messages:
    77
    Likes Received:
    17
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hello,

    I checked cPanel > Databases section > MySQL Databases and there are only 2 DBs. I've also made a backup and deleted the original "mysql-db-count" and "mysql-db-usage" from /var/cpanel/datastore/user/ folder and ran upcp --force. After the update, I reran the /scripts/update_db_cache and the issue seems to have been resolved.

    Thank you for your time.

    Regards.
     
    Infopro likes this.
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