#1 楼
请运行以下查询:SELECT
Data_BB / POWER(1024,1) Data_KB,
Data_BB / POWER(1024,2) Data_MB,
Data_BB / POWER(1024,3) Data_GB
FROM (SELECT SUM(data_length) Data_BB FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema','performance_schema','mysql')) A;
这将给您一个大概的数字。不使用列
index_length
,因为mysqldump不转储索引,仅转储数据。为了安全起见,您应该始终立即将其压缩:mysqldump --all-databases --routines --triggers | gzip > MySQLData.sql.gz
试一试!!!