[root@zabbix ~]# mysql -uroot -p
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema || mysql || performance_schema || sys || zabbix |
+--------------------+
5 rows inset(0.00 sec)
mysql> use information_schema;
mysql>select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables;#查看所有数据库的总大小
mysql>select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='zabbix';#查看zabbix数据库的大小
mysql>select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='zabbix' and table_name='task';#查看zabbix数据库中的task表的大小[root@zabbix ~]# mysqldump -BR extmail -u root -p --default-character-set=utf8 > /home/ajie/extmail20180925.sql; #备份数据库extmail到/home/ajie/目录下