Knowledge Base
MilesWeb / WordPress FAQ

How to Fix Image Links after a WordPress Migration?

Approx. read time : 3 min

Since the images in WordPress are coded differently, just changing the site URL won’t fix it. In this tutorial you will learn to fix image links by using your phpMyAdmin tool.

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

If you are a MilesWeb 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 milesweb.com, the new test site will be at test.milesweb.com so the code should appear as below:

UPDATE wp_posts SET post_content=(REPLACE (post_content, ‘milesweb.com’,‘test. milesweb.com’));

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.

You can now check how the image URL has switched to the new sitename after the SQL code is run.

Also Read:

How to migrate your HTML website to WordPress?
How to Migrate your Website from WordPress.com to MilesWeb?

Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna