MySQL相关

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;