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;