replace image links after moving wordpress site

replace image links after moving wordpress site

Technology

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.