MySQL Disk Quotas per User/Group

Grant Peel gpeel at thenetnow.com
Wed Feb 2 06:53:18 PST 2005


Hi all,

I have been struggling with how to include a users MySQL disk usage within 
thier disk quota.

Currently, each user has a disk quota set on thier /home/usernamehere 
directory

The mysql databases are kept in the /home/usernamehere/database directory, 
but, mysql insists on owning the files. (In the /usr/local/mysql/var/ there 
is a symlink to the users database directory:

/usr/local/mysql/var/usernamehere -> /home/usernamehere/database

Is there a way to setup user:group permissions so that the database 
directory is included in the users disk quota?

-Grant 




More information about the freebsd-questions mailing list