Check if databases are empty
To check if MariaDB/MySQL databases are empty in your DB Server, run the following query:
1MariaDB [(none)]> SELECT table_schema, # "DB Name",
2 -> Round(Sum(data_length + index_length) / 1024 / 1024, 1) # "DB Size in MB"
3 -> FROM information_schema.tables
4 -> GROUP BY table_schema;
5+--------------------+---------------------------------------------------------+
6| table_schema | Round(Sum(data_length + index_length) / 1024 / 1024, 1) |
7+--------------------+---------------------------------------------------------+
8| facultyblog | 970.5 |
9| information_schema | 0.2 |
10| laxnews | 65.9 |
11| exam_prodDB. | 289.4 |
12| mvlc | 17.9 |
13| mysql | 0.6 |
14| performance_schema | 0.0 |
15| piwigo | 77.6 |
16| poll | 22.3 |
17+--------------------+---------------------------------------------------------+
189 rows in set (0.439 sec)
See details in https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database