media ‘path’ issue / concern when bringing files live

Check out this search and replace plugin. The benefit of using an absolute URL is that you can easily find and replace it, either with the plugin linked above or an SQL statement or even using some built in WordPress API’s. So I wouldn’t do anything differently the next time.

I used the search and replace plugin when I moved domains. Worked great. I would just avoid using it on anything other than the post_content field of the wp_posts table. Using it for wp_options or wp_postmeta could get you into trouble because the whole serialized data thing.