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:steve@stripped]
> Sent: Tuesday, 10 December 2002 7:42 pm
> To: mysql@stripped
> 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" <deanie@stripped>
> > To: "'Steven Adams'" <steve@stripped>; <mysql@stripped>
> > 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:steve@stripped]
> > > > Sent: Monday, 9 December 2002 4:07 pm
> > > > To: mysql@stripped
> > > > 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
<mysql-thread126984@stripped>
> > > > To unsubscribe, e-mail <mysql-unsubscribe-
> > > > deanie=bigpond.net.au@stripped>
> > > > 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 <mysql-thread127086@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-
> deanie=bigpond.net.au@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
