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
I've tried creating an archive of just the moodle.xml file and it allowed me to restore it. I restored it over the top of the old room (adding to the material already there, creating just the forums and restoring user data) and it did create the forums but did not populate them with any posts. I tried restoring it to a new room (again, creating just the forums and restoring user data) but the results was the same - forums but no posts.
I have checked in the moodle.xml file and the posts are definitely in there. Why won't they restore?