mysqldump & gunzip

Create SQL Dump:
# Higher compression if bzip2 is installed on the system
# mysqldump -uwebadmin -p –all-databases | bzip2 > kimconnect.sql.bz2
mysqldump -uwebadmin -p –all-databases | gzip > kimconnect.sql.gz
 
Uncompress and import:
# If compressed by bzip2
# bunzip2 < kimconnect.sql.bz2 | mysql -uwebadmin -p
gunzip < kimconnect.sql.gz | mysql -uwebadmin -p

Leave a Reply

Your email address will not be published. Required fields are marked *