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