Search & replace serialized data after moving the files directory A drupal 6 content_field_video table holds serialized data with URLs pointing to the old site location - sites/default/files/thumb.png. Moving to the otherwise amazing Aegir-based omega8 hosting platform, we moved to a new files directory,  sites/MYSITE.COM/files/thumb.png,  so we need to convert to URLs to a new scheme. Most of the URLs are corrected by the omega8 import process, but video thumbnails are hardcoded.

What's the easiest way to do it?
The scanner module scans all CCK fields - Since this is a CCK field, it should correct this kind of problem, if this is a small database. But for large database it may suffer from performance issues.

You can also do it with PHP or SQL.