On Wed, Jan 31, 2001 at 05:45:13PM +0600, Denis V. Osadchy wrote:
> Hello, I have the problem:
>
> There is server with directory size quotes for users and user's
> access to his own MySQL database. Problem: every user can use
> unlimited disc space by creating objects in his database. How can i
> limit size of each database? I think, it's very useful thing, but i
> haven't found any solution. Please, help!
Put the database files in the users' directories (and put symlinks
where MySQL is epxecting to find them). Make sure that the user owns
the files but MySQL can write to them.
Then they'll count toward the user's quotas just like other files.
Of course, if the user goes over quota they may end up with a corrupt
table. So you have to decide if that's something you want to deal
with.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
