I did a similar thing the other day. My server had a failure which cost me my blog. Luckily I had made a backup of the sql database. (I believe its the same way the wp2.0 backup plugin works). Its a bit of a bodge around, but it worked give or take. Instructions:
http://blog.nocertainthing.co.uk/2006/02/20/importing-from-sql-dump-2/
