motammem

SELECT 
    table_name AS `Table`, 
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES 
WHERE table_schema = "__database__"
ORDER BY (data_length + index_length) DESC

motammem

#!/usr/bin/env bash
############################################
# Make all table and columns charset UTF-8 #
############################################

# Replace parameters below before use
database=[database]
user=[user]
password=[password]