#!/bin/bash

#------------------------------------------------------------------------------#

echo "
SELECT
        table_schema 'Datenbankname',
        sum( data_length + index_length ) / 1024 / 1024 'Datenbank in MB',
        data_length / 1024 / 1024 'Daten in MB',
        index_length / 1024 / 1024 'Index in MB'
FROM
        information_schema.tables
GROUP BY table_schema
;" | mysql -t

#------------------------------------------------------------------------------#