WordPress | Correcting image links after a WordPress migration

  1. Log into your cPanel interface.
  2. Once inside the cPanel, find the Databases category and click on the phpMyAdmin tool icon.
  3. You are now on the main phpMyAdmin page. Find the newly added database and click on its name from the left-hand sidebar.
  4. 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.
  5. Look to the top of the screen and you will see several tabs that run across the page. Click on the SQL tab.
  6. 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, ‘<old url>’,'<new url>’));

 

Share This Post