Hi, I was interested in implementing size limitations on specific databases.
I've searched the mysql docs for an mention of quota support, but I am not
able to find any. I found that by chown the individual database directories
and their files and then chmod them to be world readable I can access the
database. My assumption (as of yet untested) is that given the databases
group read permission would give me similar results. Then, I can make use of
Linux's quota system. The problem arises with the creation of new tables;
mysql creates all new tables as the user mysql. It doesn't seem as if it
would be too large a chore to change the source code so that the physical
files are created in the user connected to the database through (surprise!)
a mysql database. However, I don't know where I would begin such an
endeavor (any responses suggesting I start in the source code will be duly
ignored). My question is whether anyone has encountered a similar situation
and, if so, how he/she worked around/fixed it or, barring that, where I
would insert code to dynamically change the files' ownership.
Thanks
---------------------------------------------------------------------
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
