In the last episode (Jul 21), Paul Chvostek said:
> On Sun, Jul 20, 2003 at 11:43:20PM -0500, Dan Nelson wrote:
> > > For example user1 has a web space in /home/hostings/user1 and his
> > > database in /home/hostings/user1/data and user2 will have his web
> > > space in /home/hostings/user2 and database in
> > > /home/hostings/user2/data
> >
> > Create symlinks from the mysql data dir to each user's directory:
> >
> > /var/db/mysql/user1 -> /home/hostings/user1/data
> > /var/db/mysql/user2 -> /home/hostings/user2/data
> >
> > etc. Then any table the user creates in their database will end up
> > in their data dir.
>
> That'll put the files in the right directories, but if the quotas are
> based on file ownership, it won't limit the users' database size,
> since mysql wants the tables and indices to be owned by the 'mysql'
> user.
You may be able to use group quotas instead; newly-created files should
inherit the group ownership from the directory thay're in.
Unfortunately, users can chgrp files they own to any group they're a
member of, so they can "cheat" by chgrp'ing large files in their web
directory to groups like "mysql", or "users". If they are not members
of any group other than their own, this will work.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
