#mysqldump
3 one-liners with this tag.
All one-liners tagged mysqldump
Back up a single database consistently as gzip
$mysqldump --single-transaction --quick -u dbuser -p wp_example | gzip > /var/www/vhosts/example.com/wp_example.sql.gz
Back up all databases into one gzipped file
#mysqldump --single-transaction --quick --all-databases --routines --events | gzip > /root/all-databases.sql.gz
Back up each database into its own gzipped file
#for db in $(mysql -NBe 'SHOW DATABASES' | grep -Ev '^(information_schema|performance_schema|sys)$'); do mysqldump --single-transaction --quick "$db" | gzip > "/root/db-backup/$db.sql.gz"; done