mysql命令行导入sql文件

1.首先登录到mysql命令行
2.然后选择数据库
3.设置字符编码
4.导入sql文件

# 选择数据库
mysql>use dbtest;
# 设置字符编码
mysql>set names utf8;
# 执行sql文件
mysql>source /tmp/sql/back.sql;

另外提供一个查询mysql每个库大小的语句

##查询每个数据库的大小（GB）
SELECT 
    table_schema AS `Database`, 
    CONCAT(ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 2), ' GB') AS `Size_in_GB` 
FROM 
    information_schema.tables 
GROUP BY 
    table_schema 
ORDER BY 
    SUM(data_length + index_length) DESC;





##查询每个数据库的大小（MB）
SELECT 
    table_schema AS `Database`, 
    CONCAT(ROUND(SUM(data_length + index_length) / 1024 / 1024, 2), ' MB') AS `Size_in_MB` 
FROM 
    information_schema.tables 
GROUP BY 
    table_schema 
ORDER BY 
    SUM(data_length + index_length) DESC;