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.

User's MySQL Disk Usage Incorrect

Discussion in 'General Discussion' started by Jeff75, Jul 1, 2004.

  1. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    When running a quotacheck (quotacheck -av, /scripts/updatemysqlquotas, /scripts/quotacheck), it does not pick up how much space the user is taking up with their MySQL databases. For example, I have a client who is using around 16 MBs of space from MySQL in the databases directory. In their cPanel, it shows they are only using .06 MBs.

    Does anybody know how to fix this??
     
  2. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    can u check if the permisions of the databse at /var/lib/mysql is that of the user ? else chown the same to that of the user and then try.
     
  3. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    From what I understand, all MySQL databases have to be owned by "mysql" which they currently are set to. It seeems like cpanel should determine the users' mysql disk space by searching for directories in the mysql directory that begin with their login name or something along those lines.
     
  4. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
  5. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    yep.. am sorry .. i was wrong there :)

    iam digging for a solution. Please hold on.
     
Loading...

Share This Page