MySQL Dump command piped into PV with estimated progress - Cacher Snippet

8/14/2018 - 4:32 AM

MySQL Dump command piped into PV with estimated progress

MySQL Dump command piped into PV with estimated progress

mysqldump_with_progress.bash

mysqldump -u root --all-databases -q -e --add-locks | pv --progress --size 26g -t -e -r -a > dump.sql;

mysqldump -u root -p DATABASE | pv | gzip -c > commentsys.sql.gz;

 gzip -d backup-20100910164109.sql.gz
 
 tar -zxvf archive.tar.gz
 tar -zcf archive-name.tar.gz foldername/