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.

cpanel current database list is showing .sql.gz files as databases

Discussion in 'General Discussion' started by spaceman, Dec 17, 2007.

  1. spaceman

    spaceman Well-Known Member

    Joined:
    Mar 25, 2002
    Messages:
    481
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    I've recently noticed that in

    cPanel > MySQL databases

    that in the list of 'current databases' cPanel appears to be listing the .sql.gz files corresponding to each actual mysql db - AND counting these files towards the total of dbs being used by the hosting account.


    This is using cPanel 11.15.0-RELEASE

    Has anyone else spotted this? Surely a cPanel bug in need of reporting?
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Where do these .sql.gz files reside on your server?
     
  3. spaceman

    spaceman Well-Known Member

    Joined:
    Mar 25, 2002
    Messages:
    481
    Likes Received:
    0
    Trophy Points:
    16
    Ah! They reside in /home/mysql. That explains it!
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    So, you are saying:

    1. A user has some files in /home/user named db_name.sql.gz - where db_name is the same as a database owned by the user

    2. When accessing the MySQL Database page in X3, which has the URI /frontend/x3/sql/index.html, those backup files are listed as databases

    is the above a correct assessment?

    What is your full cPanel version number?
     
  5. spaceman

    spaceman Well-Known Member

    Joined:
    Mar 25, 2002
    Messages:
    481
    Likes Received:
    0
    Trophy Points:
    16
    Here's a cut and paste from the list of 'Current Databases' from the cPanel > MySQL Databases page:

    Current Databases
    Search
    Database Size Users Actions
    account_12all 3.00 MB
    account_user Delete User
    Delete Database
    account_12all.sql.gz 0.27 MB
    Delete Database
    account_complete 0.19 MB
    accoount_user Delete User
    Delete Database
    account_complete.sql.gz 0.00 MB
    Delete Database

    In answering your questions:

    1. The mysql dir had been moved some time ago (for space reasons) from /var/lib/mysql to /home/mysql. For every database dir in /home/mysql there was a corresponding .sql.gz file.

    Example:
    /home/mysql/account_primary/
    /home/mysql/account_primary.sql.gz

    Thinking that maybe it was because the mysql dir was in /home and not /var/lib that was causing this problem, we've just (last night) moved it back to /var/lib/mysql - but this has not fixed the problem.

    2. You're 100% correct

    Server info:

    cPanel Version 11.15.0-RELEASE
    cPanel Build 17853
    Theme x3
    Apache version 1.3.39 (Unix)
    PHP version 4.4.7
    MySQL version 4.1.22-standard
    Architecture x86_64
    Operating system Linux

    So something is causing these .sql.gz files to be written (possibly a backup process?), and something in cPanel is causing these files to be misindentified as actual mysql dbs.
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Something is definitely wacky there, possibly related to having MySQL reside in /home rather than /var

    Please open a support ticket at https://tickets.cpanel.net/submit/ so we can deduce what is happening, resolve it, and hopefully prevent it from happening again (and to others if possible).
     
  7. spaceman

    spaceman Well-Known Member

    Joined:
    Mar 25, 2002
    Messages:
    481
    Likes Received:
    0
    Trophy Points:
    16
    Thx. I've just done this (at last!). Problem is still there.

    Can I assume that you're now encouraging support via tickets.cpanel.net and not bugzilla.cpanel.net?
     
  8. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    The only support channel is tickets.cpanel.net The Bugzilla is for reporting (potential) bugs and feature requests. Anything that would require us to examine the system in question needs filed through tickets.cpanel.net
     
Loading...

Share This Page