Replacing Image Links after WP Migration and Installing SSL Certificate

Correcting image links after a migration

It’s capability to change your picture connects physically in your information, however, be cautioned: It will be easy to shape an oversight and any break your site. while despite everything i’ll demonstrate to you the manner in which you’ll manufacture these progressions for fulfillment, it’s fundamental to shape note of the dangers and it’s dependent upon you to pick whether you should continue.

Sign in to your cPanel interface.

Once inside the cPanel, discober the Databases section and click on the phpMyAdmin tool symbol.

Now you are watching the main phpMyAdmin page. Find the newly added database and click on its name from the left-hand sidebar.

This opens the database and the screen refreshes with a list of the tables. Using the sidebar again, find and click on the wp-posts table.

Look at the top of the screen and you will see several tabs that run across the page. Click on the SQL tab.

You are now on a MySQL editor screen. In the code area, copy the following bit of MySQL.

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

Be sure to replace with the old site name and with the new site name. For instance, our original site was ezbing.com and the new test site will be at test.ezbing.com so the code should appear as below:

UPDATE wp_posts SET post_content=(REPLACE (post_content, 'ezbing.com','test.ezbing.com'));

Click on the Go button to run the code and change the URLs for all images in the posts. This will also affect any other ‘hard coded’ links that were in the posts that pointed to the original site.

After installing an SSL certificate

That being stated, on the off chance that you wind up in an uncommon circumstance where you have to investigate your database and tables to track down some messed up picture joins, you can do this with a database search and supplant question.

Resources : https://premium.wpmudev.org/blog/replacing-image-links/