calculating disk usage per mysql database scheme

Before you migrating your website, you need to count how many MB you need for the database. To count it you need this command in mysql. Run it as user that have access to information_schema database;

select table_schema, sum((data_length+index_length)/1024/1024) AS MB from information_schema.tables group by 1;

I take this from Aaron Brown's answer here

Comments