How to Fix Image Links after a WordPress Migration?

Changing the site URL alone will not resolve the issue because WordPress images have different coding. This guide will teach you how to use your phpMyAdmin tool to fix image URLs.

Note: This step isn’t compulsory. It is essential if your domain name is changing during the migration.

If you are a Hostvento WordPress Hosting customer, we can migrate your existing website or easily get your website set up which just has WordPress installed on it.

Steps to Correct Image Links After a Migration

1. Log into your cPanel account.

2. Go to the Databases section and click on the phpMyAdmin tool icon.

3. It will open the main phpMyAdmin page. Search for the newly added database and click on its name from the left-hand sidebar. Here the database name is aaeotyee_wp231.

4. With this the database opens and the screen gets refreshed with a list of the tables. Go to the sidebar and click on the wp-posts table.

5. On the top of the screen, you will see several tabs running across the page. Click on the SQL tab.

6. In the MySQL editor screen, go to the code area and copy the below bit of MySQL.

UPDATE wp_posts SET post_content=(REPLACE (post_content," "," "));

Ensure that you replace the old sitename with the new site name. For instance, your original site was hostvento.com/kb, the new test site will be at test.hostvento.com/kb so the code should appear as below:

UPDATE wp_posts SET post_content=(REPLACE (post_content, ‘hostvento.com/kb’,‘test. hostvento.com/kb’));

In order to run the code and change the URLs for all images in the posts, click on the Go button. With this other ‘hard coded’ links will also get affected that were in the posts that pointed to the original site.

Note: The image paths are displayed in the bottom left hand corners of the images.

Now that the SQL code has been executed, you can verify how the picture URL has changed to the new sitename.