Use the query below and replace "database_name" with the correct db name. 1SELECT table_name AS "Table", 2ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" 3FROM information_schema.TABLES 4WHERE table_schema = "database_name" 5ORDER BY (data_length + index_length) …

Maximum number of table joins is 61 as per https://stackoverflow.com/questions/23389820/what-is-the-maximum-number-of-table-joins-in-mariadb Tested out as follows: 1CREATE TABLE t (i INT(10) NOT NULL); 2select * 3from t a01 join t a02 join t a03 join t a04 join t a05 join t a06 join t a07 join t a08 join t a09 join t …

1mysql -s --skip-column-names -ne "use DB_to_Use; show tables;"

1mysql -u root -p your_DB < ./your_system.sql More details in https://stackoverflow.com/questions/9696249/restoring-a-mysql-table-back-to-the-database

1mysqldump -u root -p yourDB system > yourDB_system.sql More details in https://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables