Restore MySQL Database from a backup

SSH into your server if you are working remotely. Create an empty database

mysql -u username -p -e 'CREATE DATABASE database

Now use the following command from your ssh session

mysql -u username -p database < path/to/backup.sql