If you’ve moved your WordPress installation from one URL structure to another, then you might find that certain things might break: for example, image paths.
Updating all your paths will just take a few seconds with a simple MySQL command. Go to PHPMyAdmin, a popular database management panel that your web host should provide you with, and open up your WordPress database. What we’re going to do is to perform an update of all BLOB fields, or in other words, update all the posts that you have at once.
Here’s the SQL command that you should run:
UPDATE `wp_posts` SET `post_content` = replace(post_content, 'oldurl.com/wordpress', 'newurl.com/wordpress')
- Change WordPress Category / Archive Page From Full Content to Excerpt
- How to find and replace text string in all MySQL tables
- How To Create An Anonymous or Limited Access Only Account With MySQL
- Simple Machine Forums (SMF) Photo Gallery Installation and Setup
- How To Fix: Titles Not Being Reflected When Using WordPress SEO by Yoast