On 06.02.2005 05:26 (+0100), Mark Webber wrote:
> What version of Windows? XP and Windows 2000, 2003 have built-in Quota 
> functions if you are using NTFS. Right click on the drive, choose 
> properties, click on the Quota tab.

That won't help him, and he know I think.

You can limit the folder size in Linux? How? :) Otoh, forcing filesystem
access to fail may cause massive problems for the database structural
integrity, can it? I wouldn't feel good with doing that.

My idea is still to create a little script that revokes INSERT and
UPDATE rights from the user if the database (or whatever unit you want
to check) exceeds the maximum allowed size and grant these rights again
if the size is below maximum. This script (PHP or Perl should be OK,
both are free for all platforms) can be run by the OS scheduler (Linux
cron or Windows task scheduler). If you need some PHP code for that, let
me know. It won't give you a perfect protection but I believe this is OK
for everyday use.

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>

Unclassified NewsBoard Forum --> newsboard.unclassified.de
Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to