From: Dean Harding
Date: December 9 2002 8:01am
Subject: RE: Quota Support
List-Archive: http://lists.mysql.com/mysql/126993
Message-Id: <000201c29f59$3e84c6f0$0300a8c0@dean>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

You can place the actual database files inside your user's home
directory, and sym-link to them from the MySQL's data folder.  That way
they will contribute to the user's whole quota and you don't end up with
one quota for DB and another for everything else.

The drawback, of course, is that you have to limit it to one user per
database (but each user could have more than one database).

Dean Harding.

> -----Original Message-----
> From: Steven Adams [mailto:steve@stripped]
> Sent: Monday, 9 December 2002 4:07 pm
> To: mysql@stripped
> Subject: Quota Support
> 
> Hey,
>         I was wondering if its possible to implant a quota system
where i
> can give a user just say access to 2 databases which is allowed to
grow to
> 30Mb bewteen the two of them..
> 
> What i would really like is if its possible to make mysql use the disk
> quota
> limits.. So i can give the uses say 50MB WebSpace on my server which
will
> iclude his mysql db
> 
> Thanks
> /Steve
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread126984@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-
> deanie=bigpond.net.au@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php