mysql导入导出数据
1、导出库
mysqldump -uroot -p dbname > D:\xxxx\xx.sql
2、导出某张表
mysqldump -uroot -p dbname tbname >a.sql;
3、导出表的部分数据
mysqldump -uroot -p dbname tbname –where "id>2312387" >a.sql;
4、排除部分表导出
mysqldump -uroot -p dbname --ignore-table=dbname.tbname --ignore-table=dbname.tbname2> vv.sql
5、查询每张表的数据量
#数据库中所有表的信息
select * from information_schema.tables where table_schema= '数据库名'
#数据库中每个表的数据量
select table_name,table_rows from information_schema.tables where table_schema = '数据库名' order by table_rows desc;
参考:https://blog.csdn.net/xwz960504/article/details/89875223?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-89875223-blog-122438674.pc_relevant_blogantidownloadv1&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-89875223-blog-122438674.pc_relevant_blogantidownloadv1&utm_relevant_index=1