Month: October 2020

sed -r '/INSERT INTO (mdl_table_1|mdl_table_2)/d' myslqdump.sql | gzip > "db_reduced.sql.gz"

SELECT 
     table_name AS Table, 
     round(((data_length + index_length) / 1024 / 1024), 2) Size in MB 
 FROM information_schema.TABLES 
 WHERE table_schema = "$DB_NAME";