Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By plovato on
Greetings all.
I've been tasked with archiving a Drupal 7 site under a new subdomain. In doing so, I ran an 'update replace' MYSQL query to change the links from 'www.site.tld' to 'archive.site.tld'.
The pages that were touched by the 'update replace' MYSQL query now have a blank body section. I've been manually editing each node by copying the HTML from the database ('field_data_body' table) and pasting the code ('body_value' column) into the admin panel's plain text field.
Is there a quicker way to do this? Am I missing a certain table or method? Appreciate any guidance.