How to import a database with SSH

mysql -u DB_USERNAME -p DBNAME < YOURDB_FILE.SQL

Once you’ve entered this command, you will be prompted for a password. You need to enter the database password (not the SFTP one).