Why would you need to chown it? Your user's won't need to touch the file at all, so it should be happy being owned by mysql...
I don't know, maybe it won't work... I'm not much of a Unix person - I've never touched unix since I left university :) Dean. > -----Original Message----- > From: Steven Adams [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 10 December 2002 7:42 pm > To: [EMAIL PROTECTED] > Subject: Re: Quota Support > > > So do u mean like this > > user home dir = /home/web/users/xxx > > then u symlink /home/web/users/xxx/mysql/database1 > > /usr/local/mysql/lib/database1 > > chown -R xxx.xxx /home/web/users/xxx/mysql/database1 > > Wouldent mysql get permissions errors like that? > > /Steve > ----- Original Message ----- > > From: "Dean Harding" <[EMAIL PROTECTED]> > > To: "'Steven Adams'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, December 09, 2002 7:01 PM > > Subject: RE: Quota Support > > > > > > > You can place the actual database files inside your user's home > > > directory, and sym-link to them from the MySQL's data folder. That > way > > > they will contribute to the user's whole quota and you don't end up > with > > > one quota for DB and another for everything else. > > > > > > The drawback, of course, is that you have to limit it to one user per > > > database (but each user could have more than one database). > > > > > > Dean Harding. > > > > > > > -----Original Message----- > > > > From: Steven Adams [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, 9 December 2002 4:07 pm > > > > To: [EMAIL PROTECTED] > > > > Subject: Quota Support > > > > > > > > Hey, > > > > I was wondering if its possible to implant a quota system > > > where i > > > > can give a user just say access to 2 databases which is allowed to > > > grow to > > > > 30Mb bewteen the two of them.. > > > > > > > > What i would really like is if its possible to make mysql use the > disk > > > > quota > > > > limits.. So i can give the uses say 50MB WebSpace on my server which > > > will > > > > iclude his mysql db > > > > > > > > Thanks > > > > /Steve > > > > > > > > > > > > -------------------------------------------------------------------- > - > > > > 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 <mysql-unsubscribe- > > > > [EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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
