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.