I'm in the process of restoring a number of sites. They were running on a server that was hacked very severely with (among other things) MySQL injection.
The server the compromised sites were running on was locked down by the network team and to a degree, the sites were cleaned up.
That said, I've been told short of copying and pasting the text (not even HTML) there is no way of importing the old data. In one case, the site had 241 posts and 305 comments.
What is the best approach here? The XML export file is enormous and will take a LONG time to go over with a fine-toothed comb but I could spot anything malicious and remove it I suppose.
Just trying to find out if someone has an approach I've not thought of.