Drupal 7 Site - Hardcode Links - Want to Swap to Relative - Seeking Advice

[PROFRBcom]

I've recently swapped one of our sites to new hosting and upgraded to https. 301'd everything and all of that is working well, SE are starting to index the https pages, etc. However, I have a lingering issue I'd like to address.

Before this swap, for the entire life of this particular site, all the links were hard-coded into the site as "http://example.com/content-goes-here". I'd like to change every link on the site to relative linking and thus drop the http://example.com part, leaving only "/content-goes-here" behind.

As it stands, the only way I currently know how to do this is to open every page, copy, paste, find+replace, copy, paste, save. Rinse and repeat for 1k+ pages. That seems like a nightmare and a waste of time. I was hoping there was a faster way. Someone who uses a WP site told me they were able to "open their database in Dreamweaver, find+replace, and were done in 15 seconds". I'd love to find a similar solution for my Drupal 7 site, but I can't seem to find a solution online.

I was very much hoping someone here with Drupal experience could point me in the right direction so that I'm not stuck editing 1k+ pages by hand...

[universal4]

I am not a drupal or sql pro, but you could likely export the appropriate tables to a dump file, find and replace and then import back in.

I too would be a bit nervous to do it, but you could export the entire thing, do the search and replace, then import back into a database with a new name and change the config file to look at the new database, and test everything, if it does not work as planned change the config back to the old database and you would be back to where you started.

Maybe someone here can help more.

Rick
Universal4

[Muppet]

Its a simple search and replace in the database. Here's someone asking the same thing on Stack Exchange.
https://drupal.stackexchange.com/que...-automatically

Don't forget to backup everything first and empty your cache after doing the replace.

[PROFRBcom]

Its a simple search and replace in the database. Here's someone asking the same thing on Stack Exchange.
https://drupal.stackexchange.com/que...-automatically

Don't forget to backup everything first and empty your cache after doing the replace.

Heh, never as simple with me it seems... we have no shell access in our new hosting environment:

Does Pantheon have FTP or shell access?

Pantheon supports toggling between local development mode using git push to transfer all code changes, and an on-server development mode, which provides access to the codebase via SFTP.
Direct SSH access is not supported, but you are able to directly interface with mysql, use CLI tools (Terminus, drush, WP-CLI, and SFTP files.

Also, thanks for that link!

[Muppet]

"Direct SSH access is not supported, but you are able to directly interface with mysql" - that is all you need.