MySQL - How to get database sizes

MySQL provides metadata of the database itself, basically just run this on your query. Don't forget to replace database name with yourown database name. SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)...