Thread: Some questions
View Single Post
Old 15th March 2012, 17:45
tom123 tom123 is offline
Join Date: Feb 2012
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts

MySQL can show the data size for each database in a query like this:

SELECT table_schema AS database_name, 
SUM(data_length + index_length)/1024/1024 AS db_size
FROM information_schema.TABLES 
GROUP BY table_schema ;
so you can sum this size to the quota script, like every other control panel does.
Reply With Quote