I have a procedure for "backporting" the contents (i.e. databases and uploaded files) of our production wikis to their dev copies. The wikis are in AWS using Aurora MySQL, so part of the procedure is to create snapshots of the four production database clusters and restoring them as new dev clusters. However, the iw_url values that link pages across the four wikis (EN, DE, FR, ES languages) contain the hostnames of the production wikis, so the dev wikis' interwiki links redirect to the production wikis. Would it be safe to simply run a SQL command to update the iw_url values in the dev wikis' databases, or might there be a better approach (other than manually logging in to each wiki to edit the Special:Interwiki pages manually)?
