Hi,
I have used cloudinary to upload media, and now we have changed our cloudinary accounts and media URL has been chnaged. I am looking a way to update the media URL for all my assests. What would be the best appraoch?
Hi,
I have used cloudinary to upload media, and now we have changed our cloudinary accounts and media URL has been chnaged. I am looking a way to update the media URL for all my assests. What would be the best appraoch?
Not sure if the best approach, but I’ve done this in the past connecting to the db itself and using an UPDATE query to modify the path of all URLs.
Something like:
UPDATE files
SET
url = REPLACE(url, 'domain1.com', 'domain2.com'),
formats = REPLACE(formats::text, 'domain1.com', 'domain2.com')::jsonb
However, It’s important to first create a backup of the db and test the query in a local environment to check everything works as expected before doing it in a production environment.
Hope this helps!
Esteban
Thanks for helping the question.
Waiting for your discovering!