Sometimes you need to dump a mysql database, and there’s no free space on the server. Here’s you can do to back up the database:
ssh -p <ssh port> user@host "mysqldump -u dbuser -ppassword dbname | gzip -9" > database.sql.gz
At the end you will get mysq database on a local server. Although ssh is slow and it would take some time to transfer the database.