To backup your database through SSH (create SQL dump):
mysqldump --opt -u user -p dbname > {path}/backup.sql

To restore:
mysql -u user -p dbname < {path}/backup.sql