Search & replace serialized data after moving the files directory
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.