Thanks Alexander, It is really a good solution. But a small problem again. When I drop a user1_db database, mysql does not allow me to drop it and throw a error
[root@myserver mysql]# mysqladmin drop user1_db -u root -p Enter password: Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'user1_db' database [y/N] y mysqladmin: DROP DATABASE user1_db failed; error: 'Error dropping database (can't rmdir './user1_db', errno: 20)' Thanks & Regards Praful ----- Original Message ----- From: "Alexander Keremidarski" <[EMAIL PROTECTED]> To: "Praful Saijare" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 19:31 Subject: Re: quota on mysql > 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 > > > > > > > "Incoming mail has been certified virus free by Cyquator using fully automated antivirus protection powered by McAfee." > > > --------------------------------------------------------------------- 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
