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
Hi Mike,
Check out HyperBac for MySQL, this does integrated compression and encryption of mysqldump’s without using pipes, it is faster than most algorithms out there (including bzip). The product is available for MySQL on Windows and Linux royalty free. Solutions are also available for Oracle, MSSQL and other platforms, all working with native backup interfaces for the various platforms.
Regards,
Jeff
Thanks for the information Jeff. I added the link to the product in your comment. Thanks again for sharing.
Cool :) thanks a lot