Исправление линков на картинки после переезда

Исправление линков на картинки после переезда

взято отсюда: http://www.inmotionhosting.com/support/edu/wordpress/migrating-wordpress-inmotion-hosting/correct-image-links

Correcting image links after a migration

Log into your cPanel interface.

select phpmyadmin tool. Once inside the cPanel, find the Databases category and click on the phpMyAdmin tool icon.
select new databaseю You are now on the main phpMyAdmin page. Find the newly added database and click on its name from the left-hand sidebar. Our sample database is named testdb.
select database tableю 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 (or similar).
click the SQL button. Look to the top of the screen and you will see several tabs that run across the page. Click on the SQL tab.
enter the SQL code and run it.
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 sitename and with the new site name. For instance, our original site was inmotiontesting.com and the new test site will be at test.inmotiontesting.com so the code should appear as below:

UPDATE wp_posts SET post_content=(REPLACE (post_content, ‘inmotiontesting.com’,’test.inmotiontesting.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.

Below are before and after shots of the changes made. Note that the image paths are displayed in the lower left hand corners of the images. You can see how they switched to the new sitename after the SQL code ran.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *