SQL to get the size of your database (data, indexes, totals)

get_database_size.sql

-- SQL to calculate the size of your database (data, indexes, total).
-- Replace the "DATABASE_NAME in the 2nd to last line with the name of your DB
SELECT concat( table_schema, '.', table_name ) table_name,
   concat( round( data_length / ( 1024 *1024 ) , 2 ) , 'M' ) data_length,
   concat( round( index_length / ( 1024 *1024 ) , 2 ) , 'M' ) index_length,
   concat( round( round( data_length + index_length ) / ( 1024 *1024 ) , 2 ) , 'M' ) total_size
   FROM information_schema.TABLES
   WHERE table_schema = 'DATABASE_NAME'
   ORDER BY data_length DESC;