With one of our current Moodle 1.9 installations we have many course resources and files that are hyperlinked to items stored in Moodle site files. So it the html property might look like http://site.com/moodle/file.php/1/files. I need to move those files to a different location. So the new hyperlink reference would look like http://site2.com/files
I don't even know what table to look at. I have hundreds these and dealing with the Moodle interface will take a lot of time.