From owner-freebsd-questions@FreeBSD.ORG  Wed Feb  2 14:53:18 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 36E7C16A4CE
	for <freebsd-questions@freebsd.org>;
	Wed,  2 Feb 2005 14:53:18 +0000 (GMT)
Received: from enterprise.thenetnow.com (enterprise.thenetnow.com
	[65.39.193.152])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 945C443D2D
	for <freebsd-questions@freebsd.org>;
	Wed,  2 Feb 2005 14:53:17 +0000 (GMT)
	(envelope-from gpeel@thenetnow.com)
Received: from GRANT (hpeel.ody.ca [216.240.12.2])j12ErDR00311
	for <freebsd-questions@freebsd.org>;
	Wed, 2 Feb 2005 09:53:13 -0500 (EST)
	(envelope-from gpeel@thenetnow.com)
Message-ID: <010e01c50937$17852460$6401a8c0@GRANT>
From: "Grant Peel" <gpeel@thenetnow.com>
To: <freebsd-questions@freebsd.org>
Date: Wed, 2 Feb 2005 09:54:24 -0500
Organization: The Net Now
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Subject: MySQL Disk Quotas per User/Group
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Grant Peel <gpeel@thenetnow.com>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 02 Feb 2005 14:53:18 -0000

Hi all,

I have been struggling with how to include a users MySQL disk usage within 
thier disk quota.

Currently, each user has a disk quota set on thier /home/usernamehere 
directory

The mysql databases are kept in the /home/usernamehere/database directory, 
but, mysql insists on owning the files. (In the /usr/local/mysql/var/ there 
is a symlink to the users database directory:

/usr/local/mysql/var/usernamehere -> /home/usernamehere/database

Is there a way to setup user:group permissions so that the database 
directory is included in the users disk quota?

-Grant