-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I dont have hard quota's, It is a script that looks at the userdir and tells them if they are over the limit, then if they are xMb over the limit the admin is notified. Yes, I could modify this script, but I would rather have all the user's data in thier homedir, as I have for thier apache conf, thier mail, their web data, thier ftp data, etc etc etc.
- -----Original Message----- From: Mike Rogers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 2:19 PM To: Nathan Ward Subject: Re: MySQL data in user dirs If you want your backends to crash when a user reaches their quota, that would be an amaizing idea. I doubt that is actually intended though. How about a simple script which will just look at the size of the database file, or look at the size of the data in the database [edit the new phpMyAdmin and see what query they use to find out the size of each database]. Make a cron job that every hour runs and gets the value, compares it to their quota and sends them an e-mail or notifies the admin to whine to them. Otherwise, you are creating havok for yourself. Besides- Disk space is cheap. Just pick up a 180GB [one hundred and eighty gigabytes] Seagate SCSI drive (10kRPM, U160) dirt cheap. Or even a few 9's or 18's. Or if you want to skimp, go IDE and get 100GB for 200$CDN. - -- Mike - ----- Original Message ----- From: "Nathan Ward" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 9:10 PM Subject: MySQL data in user dirs > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > How to I put a users MySQL data into thier home dir? I have tried > moving thier database over and sym-linking it: > > mv /var/lib/mysql/userdb /home/user > ln -s /home/user/userdb /var/lib/mysql/userdb > > But mysql doesnt see the database. > > I also tried to move and symlink the tables themselves: > mkdir /home/user/userdb > mv /var/lib/mysql/userdb/* /home/user/userdb/ > ln /home/user/userdb/... /lib/mysql/userdb/... (a few times) > > And it works. > > What I am a trying to achieve is to have the user's MySQL data size > restricted by thier quota. > Any suggestions? > > -----BEGIN PGP SIGNATURE----- > Version: PGP 7.1 > > iQA/AwUBO99PjMGemXVaU1CGEQJDmwCfRB/aK/jiX0nZWLAjhWAx9pkUK7AAn3Au > IiJogSGR/oTeuANl2CcaJ85p > =6vec > -----END PGP SIGNATURE----- > > > > -------------------------------------------------------------------- > - 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 > > -----BEGIN PGP SIGNATURE----- Version: PGP 7.1 iQA/AwUBO99UVsGemXVaU1CGEQJMVQCg2HeTmW3fnZsZKMct7vNW1hN7O+QAn3NY +AbMFtoNMlV7m0IyQ8d+7iRN =/+Z3 -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
