I need to migrate my site from a local host to a hosting service so I've been reading up on transferring the tables. I have a lot of images linked to URLs so I was hoping to export the table as a CSV file and do a find/replace to update the image file locations. Unfortunately, my export downloads as a CSV.HTML file. I opened it in TextMate and then tried copying and pasting the text into Excel, but the data is not properly delimited.
I've come to conclusion that I'm going to have to import the dump file of each table and manually change the image file locations; but, I am hoping you have another suggestion.