I recently had a little accident (of the SQL kind) and overwrote every message posted on our forums with a correction that I had only intended to overwrite a single post.
I tried to restore the latest backup but it seems all of my backup zips are partially corrupt (incomplete central directory). I have downloaded and recovered most of the backup zips but I don't know how many files are missing. One critical file that appears to be intact is the SQL database backup, moodle.xml.
How can I restore the database from moodle.xml? I don't know how to get MySQL to import from the XML. I'm not worried about the other files as I'm pretty confident that nothing else has changed on the site since the last backup - only the database content.
If I create a zip file containing ONLY moodle.xml and place it in the backup directly, will it restore just that file?
EDIT: Moodle 1.9.1