Do not change Media URLs

Hi,

To keep the URL the same you will have to skip/deselect the “Search and Replace database” option. After the restore the links for the images will point to the original source site. Our restoration guide is here.

Thanks,
Bryle

Hi,
Thanks for the reply, I did but I think I’m doing something wrong.
I started the restore, and unchecked “search and return” of the database, but once completed, the site was inaccessible and redirected to the original site.

Maybe only one table needs to be deselected?
You can explain.
Thank you

Doing a full restore and changing only the media urls to the old site afterwards seems like a more promising approach.

Hi @magictrashcan,

thanks for your reply, it seems like a good solution, sorry, but how do I restore the media URLs?

Thank you

Off of the top of my head, I did not test it but this approach should work:

Log on to your SQL, search and replace all urls in the wp_posts table. You may need to adjust the script to your respective table prefix (where it says wp_posts).

UPDATE wp_posts SET post_content = replace(post_content, 'https://www.stagingurl.com/wp-content/uploads', 'https://www.liveurl.com/wp-content/uploads');

The key is to only update the links that include the wp-content/uploads bit. That leaves all other urls intact.

All images loaded in your posts/pages should now be loaded via the live url.

Not 100% sure if there are theme files that may need updating in another place but you can repeat the above code on any table/cell.

That being said, always take a backup before fiddling around with the database, even if it’s just a staging site. Saves you a lot of trouble.

Hi @magictrashcan
thanks for your reply and your solution!

I thought there was something in the plugin that needed to be deactivated so as not to have to be rewritten.

I will try your code thanks!

Not keeping the option to search and replace checked would have been the cause of this. We do have a guide for such occurences: https://updraftplus.com/faqs/migrated-site-searchreplace-database-can-now/