replace image links after moving wordpress site
Posted On August 3, 2013
after you move your wordpress site to a new domain or path, the image links will likely be broken
this simple SQL query will help fix the problem in short order
using your mysql manager, like phpmyadmin or the command line, open your blog database (usually wp_something). This command can be updated to meet your needs
MAKE A BACKUP FIRST.
you’ll want it if anything goes wrong.
UPDATE wp_posts SET POST_CONTENT = replace(POST_CONTENT, ‘www.myoldsite.com/blog’, ‘www.mynewsite.com’);
mine was done in less than one second.