List:General Discussion« Previous MessageNext Message »
From:Dean Harding Date:December 10 2002 8:32pm
Subject:RE: Quota Support
View as plain text  
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


Thread
Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent5 Dec
RE: Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent8 Dec
  • Re: Can't connect error 10061 - nothing but Mascon works remotely.iConnect \(Berlin\) Stefan Hinz8 Dec
    • RE: Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent9 Dec
      • Re: Can't connect error 10061 - nothing but Mascon works remotely.Listen Hinz9 Dec
        • RE: Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent10 Dec
          • Re: Can't connect error 10061 - nothing but Mascon works remotely.iConnect \(Berlin\) Stefan Hinz10 Dec
            • RE: Can't connect error 10061 - nothing but Mascon works remotely - SOLVED (sorta)Daevid Vincent10 Dec
RE: Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent9 Dec
  • RE: Can't connect error 10061 - nothing but Mascon worksremotely.Michael She9 Dec
    • RE: Can't connect error 10061 - nothing but Mascon works remotely.Daevid Vincent9 Dec
      • Quota SupportSteven Adams9 Dec
        • RE: Quota SupportDean Harding9 Dec
Re: Quota SupportSteven Adams10 Dec
  • RE: Quota SupportDean Harding10 Dec
    • Re: Quota SupportSteven Adams11 Dec
      • Re: Quota SupportCedric Veilleux11 Dec