Replace Drupal development URLs with live URLs
For those of you who found our last post helpful; WordPress URL Replacement Queries for MySQL, we also often get the question about how to update URLs in Drupal after migrating from development to a live server. We feel it’s time to share a secret that will make your life a lot easier than updating each and every page, post and/or custom post in your site. The answer are these WordPress URL replacement queries for MySQL.
UPDATE block_custom SET body = REPLACE(body, 'ENTER DEV BASE URL', 'ENTER LIVE BASE URL'); UPDATE field_revision_body SET body_value = REPLACE(body_value, 'ENTER DEV BASE URL', 'ENTER LIVE BASE URL'); UPDATE field_data_body SET body_value = REPLACE(body_value, 'ENTER DEV BASE URL', 'ENTER LIVE BASE URL');
Simply replace the ‘ENTER DEV BASE URL’ with the base url or your development server, for example: https://localhost/summus.io. Then, replace ‘ENTER LIVE BASE URL’ with the base url to your live server, for example: https://summus.io.
You can use https://www.drupal.org/project/pathologic to do this. If configured correctly it’s transparent.