1.查看数据库大小
use information_schema;
select concat(round(sum(DATA_LENGTH/1024/1024),2),‘MB‘) as data from TABLES where table_schema=‘dbname‘;
2.导出数据库数据
mysqldump -h10.10.130.118 -uigame -p dbname > filename.sql;
3.导入数据库数据
mysql -h10.10.130.118 -uroot -p dbname < filename.sql;
原文：http://www.cnblogs.com/wkccs/p/5653251.html