Change old URLS in MySQL
-
Hello, I have a new WordPress instance and I copied over my old database.
I am now storing my images in a new Azure storage instance and new URL.
When I open up the media gallery and go to one of my older images, it has the older Azure storage file path associated with it.
How can I update that to the new URL? I tried updating a couple of tales but it did not work.
UPDATE wp_posts SET guid = replace(guid, ‘https://prodmediacdn.blob.core.windows.net’,’https://office-insider-media.azurefd.net’) WHERE ID IN (3281)
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘https://prodmediacdn.blob.core.windows.net’,’https://office-insider-media.azurefd.net’) WHERE meta_id IN (15631,15633)
- The topic ‘Change old URLS in MySQL’ is closed to new replies.