-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