Import - Export using SSH

To Import Database : 

mysql -u ..... -p
connect dbname

source /var/www/html/oss2/DATABASES/prod_us.sql
 
To Export Database : 

mysqldump -u username -p db_name > /home/iovista/public_html/magento/dbname_dump.sql

OR

mysqldump -u username -p db_name | gzip > /home/subside/public_html/dbname.sql.gz