I have a heap of images inside MovableType, on an old server. There are plenty which have character entities like %20 to represent spaces.
I've used some plugins to import the images and change the URLs inside posts, but while MT can deal with /my%20dog.jpg, WP just shows a 404.
Assuming there's no way to get WP to display these images, and I have to rename them, what's the best way to:
- Rename all the files (strip out character entities)
- Rename all the URLs referenced in posts
I'm a little bit stuck here and not sure what the best way of solving this would be, whether via SSH and SQL queries, or otherwise.