The plugin intention is to provide you with what you need if you have any issues with your website. We had intended at the start that if a big serious problem happens and a full restore is needed, users would be able to seek help from people with a little technical knowledge with getting the bits restored.
We have been planning for a while now to add automated recovery to the plugin, so you can install it to a blank WordPress and recover a backup. But such a process is not simple and with the plugin writing data to the entire WordPress installation and database instead of just reading data it means no room for error. This process also needs to be straight forward and just work - if it goes wrong even slightly we end up at square one needing a technical person to assist.
There are quite a few guides to restoring backups of the database around. There is one from WordPress here: http://codex.wordpress.org/Restoring_Your_Database_From_Backup
The complication is our backup won't overwrite so you'll need to stay on the table list and click all the checkboxes and then click the red X to delete existing tables. We're changing this in a future version so the backup will overwrite.
This seems to have some good instructions too:
Just note the key bit at the bottom:
"You need to drop all of the database tables first (not the database itself). This is done by going to “Structure”, and then if you see the entire list of tables, scroll down and check “Check All”. Once all tables are selected, beside it you will see “With selected”, select “Drop”. Then click "Yes". Once it is empty, execute Step3 to Step 6 again.
Read more at http://www.devshed.com/c/a/MySQL/Backup-and-Restore-a-MySQL-Database/1/#85q7lqYgMZcG68fb.99 "