serth

For the record, I DL-ed my sql DB, changed all instances of old staging site URL to current and uploaded. voila everything works.

Welp, brought the stylesheet back but no images yet. AUGH!

I read elsewhere guids are essentially not entirely important except for RSS feeds and images. Since my images are nowhere to be found in the browser, will changing the guid for each image within the database help bring those back to life?

I have an idea of what is going on but I cannot find the solution.

Could this be done by changing guid within the database?

All of the images have guids of ‘stagingsite.com/wp-content/….’
I would like to select each of those and simply replace the old url with the new url, while maintaining the path (…/wp-content/uploads/….)

How can this be done?

Let me sum up the problem based on what I know:

Images and the css file are being linked to their staging site we’ll call ‘stagingsite.com’. While the rest of the content has a path to the actual site.

How can I change the path for all the content linked to ‘stagingsite.com’ to the actual siteurl?

everything seems to have been located elsewhere and that site has been shut down. how can I point the data back? all of the content has been verified to exist at ‘…/blog/’

Can I change the value for siteurl and homeurl in the database?

images are not viewable either.