Re: How to enforce disk quotas for MySQL users?

From: those who know me have no need of my name (not-a-real-address_at_usa.net)
Date: 07/12/03


Date: 12 Jul 2003 02:53:54 GMT

in comp.unix.admin i read:

>I want to be able to enforce disk quotas on my MySQL users.

>I tried this, which *almost* worked, (with example user "x"):
> * move data files to directory in user x's home directory
> * chown all data fils to x:mysql
> * simlink to the data directory from the MySQL default data directory

>Setting SGID worked -- it forced group ownership on new files -- but I can't
>see how that will help me enforce *user* quotas.

one group per user, with on that user as a member, the db directory set
sgid that group with a *group* quota applied.

-- 
a signature


Relevant Pages

  • Re: SOS! Root filled, want to recover MySQL data!
    ... Davide Bianchi wrote: ... the data directory associated with my MySQL ... Is the MySQL data directory in the root partition or on another ...
    (comp.os.linux.setup)
  • Re: MySQL 3 needed but how?
    ... Starting mysqld daemon with databases from /var/db/mysql ... The data directory is correct. ... Then restart the mysql service. ...
    (freebsd-questions)
  • Re: SOS! Root filled, want to recover MySQL data!
    ... logged into my server an hour ago just to find that the root partition ... the data directory associated with my MySQL ... It is more accurate to compare Israel to the communists than the Nazis ...
    (comp.os.linux.setup)
  • Re: fc2 mysql binary install question
    ... > Where was it intended the data directory be placed within fc2 for mysql ... > install packages don't make a data subdirectory so far as me and locate ...
    (Fedora)
  • Re: Moving a MySQL database
    ... providing you're using the same or a newer mysql server on your new system, you just need to copy the whole data directory of your mysql installation. ... > I have a MySQL database residing on a RH9 server. ...
    (Debian-User)