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