Thanks David, this is exactly what I did, which is probably why I’m in this situation. “First, what not to do: Don’t use WordPress’ Export tool (Tools > Export, from the WordPress Administration area). This often results in lost content and images that don’t work – they get put in the wrong uploads subfolder, making them not show up on your site.”
Should I start over again or try to run the queries you mentioned?