This is an old revision of the document!


MySQL Dump

Dump database without create db

mysqldump -ER --triggers --tz-utc -e --default-character-set=utf8 -r -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
Navigation
Print/export
QR Code
QR Code wiki:mysql (generated for current page)