Well hows it spoes to work with disk qoutas if u dont chown it to the user id??
/Steve ----- Original Message ----- From: "Dean Harding" <[EMAIL PROTECTED]> To: "'Steven Adams'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 7:32 AM Subject: RE: Quota Support > 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 > --------------------------------------------------------------------- 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
