msyqldump
Dump a Database
mysqldump -u [username] -p your_database_name > outputfile.sql
Compress it
tar -czvf outputfile.tgz outputfile.sql
Import a Dump
mysqldump -u [username] -p your_database_name < outputfile.sql
IT Notes from various projects because I forget, and hopefully they help you too.
mysqldump -u [username] -p your_database_name > outputfile.sql
tar -czvf outputfile.tgz outputfile.sql
mysqldump -u [username] -p your_database_name < outputfile.sql