常用SQL语句
##导出所有数据库的数据mysqldump -u root -p123456 --all-databases > all.sql##导入所有数据库的数据mysql -u root -p123456 < "/root/all.sql"
##导出整个数据库mysqldump -u dbuser -p dbname > dbname.sql导入mysql -u root -p123456 test < "/root/all.sql"
##导出整个数据库mysqldump -u dbuser -p dbname users> dbname_users.sql
##查看所有表信息
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mall'##查看各个表数据量SELECT table_name,table_rows FROM information_schema.tables
WHERE TABLE_SCHEMA = 'mall' ORDER BY table_rows DESC;
统计一下所有库数据量
每张表数据量=AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH
SELECT
SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb
FROM information_schema.TABLES统计每个库大小：
SELECT
table_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb
FROM information_schema.TABLES group by table_schema;
页:
[1]