RE: [PHP] Amount of data in the database
| From: | Timothy Hitchens \(HiTCHO\) | Date: | Sun, 12 Jan 2003 05:29:32 +0000 |
| Subject: | RE: [PHP] Amount of data in the database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131307@lists.php.net to get a copy of this message | ||
Give this a go.. for each of the databases use:
SHOW TABLE STATUS FROM xxxxxx;
That will return a huge amount of size etc data!!
Timothy Hitchens (HiTCHO)
Open Platform Consulting
e-mail: tim@hitcho.com.au
> -----Original Message-----
> From: Denis L. Menezes [mailto:menezesd@singnet.com.sg]
> Sent: Sunday, 12 January 2003 2:58 PM
> To: PHP general list
> Subject: [PHP] Amount of data in the database
>
>
> Hello friends.
>
> I have a need for checking how much data(in kb) exists of
> each of the user members in the MySQL so that when they
> upload more data I can restrict/warn them of the amount of
> data they have on the server at present.
>
> can anyone please tell me how to check the amount of data on
> the mysql for each record?
>
> thanks very much
> Denis
>