Mysql Dump
Jump to navigation
Jump to search
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}
import Dump
Character set e collation
select schema_name,default_collation_name,default_character_set_name from information_schema.schemata;