Resolve all domains from a CSV export of the wp_domain_mapping database table

resolve_wordpress_mu_domains.sh

#!/bin/bash
INPUT=wp_domain_mapping.csv
OLDIFS=$IFS
IFS=,
[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; }
while read domainid siteid domain active
do
	domain=${domain//\"} # Remove quotes
	domainid=${domainid//\"} # Remove quotes
	ip=`dig +short $domain | tail -n 1` # Resolve domain name
	echo "$domainid,$domain,$ip" # Write output in CSV format
done < $INPUT
IFS=$OLDIFS