MySQL Import Export

mysqldump -u [username] -p dbname] | gzip > filename.sql.gz
mysqldump -u [username] -p [dbname] > filename.sql

gunzip < [filename.sql.gz ] | mysql -u [username] -p[password] [dbname]