At 10:28 AM 5/17/2002, you wrote:
>Hello,
>
>----- Original Message -----
>From: "Egor Egorov" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, May 17, 2002 1:42 PM
>Subject: Re: How to limit database size?
>[how to limit database size?]
> >
> > You can't do it with MySQL, use disk quotas ...
> >
>
>Thanks for your answer.
>
>What happens if a user tries to add more data to a table after the files
>containing his database reached the hard disk quota limit. Does it make any
>diffrence which file (.frm .myi .myd) reaches the disk quota limit ?
>
>Alexander Newald
Alexander,
Why not just have a record_limit column in the Member table that
limits the member to a certain # of records. Before he inserts a new
record, you do a lookup using his member_id and see if he is about to
exceed his limit. If he does, display a warning message that allows him to
buy more record space. You make more money off of him and if he doesn't
like it, he is limited to the # of records he has and he will manage his
records better. It is all automatic.
Mike
---------------------------------------------------------------------
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
