Copied a compressed database backup from the Production server to the Development server. The database backup file was compressed using bzip2 while piping from mysqldump.
mysqldump -u root -p –databases perfparse | bzip2 -z1 > perfparse.bkp.bz2
bzip2 Options
z = compression
1 = fastest compression (compared to 9 = best compression)
Used bunzip2 to uncompress while piping to mysql due to limited disk space.
bunzip2 < perfparse.bkp.bz2 | mysql -uroot -p
Very basic information, but I do use this blog for referring myself and others back to my notes.
References
Compressing mysqldump output
bzip2 Home
Posted by mrothouse 
