On Tue, 8 Oct 2002, Jesse Sheidlower wrote: > I'm sure this is a common requirement, but the only thing I could > find in the docs or in a book or two was an unanswered version of > the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html . > > I'm setting up MySQL on a small ISP and would like to be able to > restrict the size of individual databases to something like 25M. > What's the best way of getting this done? The server is running > Solaris, if it's necessary to do it through the OS insteady of > through MySQL.
Hi, Unfortunately you'll have to use Solaris disk quotas for that. Make sure that the table files of each restricted-space user count towards their personal quotas. This means that you have to create a separate OS account for each user you want to restrict with the quota. This also means that the table files must be owned by those restricted users. I hope this quota feature will be added into MySQL in the future. Best regards, Iikka ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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