[sudhakararaog]

hi

i have mysql database installed on the main webserver and i use a pc through the lan. i have couple of tables in different databases.
my question is using php and mysql methods can i write a code which would connect to the server where mysql has been installed on the unix server and report on the following

1. total capacity of mysql database installed on the unix server's hard disk (this is NOT considering the entire capacity of the server's hard disk capacity ONLY the total amount of data capacity that mysql can hold on the unix server's hard disk)

2. total amount of data already used with the existing tables

3. amount of data left that the mysql database can accept

please provide the code.

thanks.