Tag Archives: Database size

Database size phpadmin wordpress

WordPress Database size in phpMyAdmin

How to show WordPress database size in pypmyadminI got an email from my hosting provider that I was exceeding my wordpress database space of 1000MB, which I thought was very strange. Had 2 dabases in which I each imported content of about 50MB (gzip format). I could not find the actual database size so I did some digging around and found the SQL code below which does the trick:

SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

Continue reading WordPress Database size in phpMyAdmin