Mysql Dump

Creazione Dump

Dump dei dati di un singolo database

mysqldump --no-create-info --no-autocommit --hex-blob --single-transaction --quick --flush-logs --set-gtid-purged=OFF --log-error=log.data.log --result-file=$db.data.sql --skip-lock-tables ${DB}

Dump dei metadati di un singolo database:

mysqldump --no-data --no-autocommit --hex-blob --single-transaction --quick --flush-logs --set-gtid-purged=OFF --no-tablespaces --triggers --routines --events --log-error=log.meta.log --result-file=db.matdata.sql --skip-lock-tables ${DB}

Character set e collation

 select schema_name,default_collation_name,default_character_set_name from information_schema.schemata;

Grandezza dei database

SELECT 
   table_schema AS 'Schema',
   ROUND(SUM(data_length + index_length) / (1024 * 1024), 2) AS 'Dimensione (MB)'
FROM 
   information_schema.TABLES
GROUP BY 
   table_schema
ORDER BY 
   SUM(data_length + index_length) DESC;