HI,
Praful Saijare wrote:

>Hi all,
>   How do I go about applying user quota on mysql databases, so that I =
>can keep track of the disk space used by all the databases users.
>
>I am using RH linux 7.0 =20
>Mysql 3.23.40  installed on /var/lib/mysql/
>quota-2.00pre3-7 applied on /home partation
>
>Thanks in advance
>Praful
>
Place user databases in their home dirs with some conventional names and 
make symlinks into mysql datadirs.

Example:

mkdir /home/user1/mysql_db
chmod 700 /home/user1/mysql_db
chown mysql home/user1/mysql_db
ln -s /home/user1/mysql_db /var/lib/mysql/user1_db


-- 
Best regards
-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Alexander Keremidarski <[EMAIL PROTECTED]> 
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Sofia, Bulgaria
       <___/   www.mysql.com   M: +359 88 231668





---------------------------------------------------------------------
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

Reply via email to