This is an old revision of the document!
MySQL Dump
Dump ALL databases
mysqldump -ER --triggers --tz-utc -e --default-character-set=utf8 --master-data=2 -r $(date '+%y%m%d-%H%M%S')-all-databases.sql --all-databases
Dump database without create db
mysqldump -ER --triggers --tz-utc -e --default-character-set=utf8 -r $(date '+%y%m%d-%H%M%S')-database.sql database
Dump database with create db
mysqldump -ER --triggers --tz-utc -e --default-character-set=utf8 -r $(date '+%y%m%d-%H%M%S')-database.sql -B database
Edit Dump
Cut single database from dump
sed -n '/^-- Current Database: `database`/,/^-- Current Database: `/p' all-databases.sql > database.sql
Cut single table from dump
sed -n '/^-- Table structure for table `licenses`/,/^--Table structure for table /p' database.sql > table.sql
