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.

Quota on MySQL DB !?!...

Discussion in 'General Discussion' started by parisdns, Jan 31, 2005.

  1. parisdns

    parisdns Active Member

    Joined:
    Aug 4, 2004
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    PrivateLayer.com
    Just wonder how to set quota on MySQL DB for a account:

    -limit #DB/account
    -limit #tables/account
    -disk space/account

    Many webhosting company do it, so I guess it's possible with cPanel or other control panel.

    Any awnsers, guys !?!... :eek:
     
  2. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Limiting number of databases per account is already available in the package creation/edit stuff. Setting a quota on # of tables, is I am pretty sure, not possible. As for making the MySQL databases count against the user's set quota, would require the user's databases chowned to the user. I believe there is a script in /scripts, however forget what it is.
     
  3. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    ithink /scripts/updatemysqlquota would do the job for you
     
Loading...

Share This Page