How can I roll the database back to the backup
You can use Drush.

All you need to do is to run, inside a Drupal instalation, the following command:

drush sqlc &lt; path/to/backup.sql

*You may want to drop your current database before that. The command is:

drush sql-drop -y