MySQL Backup

install utilities:
- pigz - multithreaded gzip implementation of gzip
- pv - progressbar
yum install pigz pv -y
Backup
mysqldump --extended-insert --single-transaction mydb | pigz > mydb-backup.sql.gz
Restore
# default
gunzip  < mydb-backup.sql.gz | mysql mydb
# or multithreaded
unpigz < mydb-backup.sql.gz | mysql mydb

# with progressbar
pv mydb-backup.sql.gz | unpigz | mysql mydb