HOSTFILE=domains.txt
IP="**********"
path="************"

echo -e "\e[1;31;44m *** \e[37mStarting Domain Migration script: `date`\e[31m***  \e[0m"
cd $path
for host in $(cat $HOSTFILE)
do
echo $host
domain=$host

mkdir $path/$domain
ssh -C root@$IP tar -C /var/www/vhosts/$domain/httpdocs -cpzf /var/www/vhosts/$domain/migrate.tar.gz . < /dev/null
scp root@$IP:/var/www/vhosts/$domain/migrate.tar.gz $path/migrate.tar.gz < /dev/null
tar -xpzf $path/migrate.tar.gz -C $path/$domain < /dev/null

dbname=`cat $path/$domain/wp-config.php|grep "DB_NAME"|awk -F"')" '{print $1}'|awk -F"', '" '{print $2}'`
dbuser=`cat $path/$domain/wp-config.php|grep "DB_USER"|awk -F"')" '{print $1}'|awk -F"', '" '{print $2}'`
dbpass=`cat $path/$domain/wp-config.php|grep "DB_PASSWORD"|awk -F"')" '{print $1}'|awk -F"', '" '{print $2}'`
ESCdbpass=$(echo "$dbpass" | sed -e 's/[]\/\!\}\$\&\"\;|*.^|[]/\\&/g')
newdbuser="db"$RANDOM
newdbname="db"$RANDOM
newdbpass="db"$RANDOM
echo "OLD NAME: $dbname NEW NAME: $newdbname"
echo "OLD USER: $dbuser NEW USER: $newdbuser"
echo "OLD PASS: $dbpass NEW PASS: $newdbpass"

php $path/database.php newdbuser=$newdbuser newdbname=$newdbname newdbpass=$newdbpass
echo "database created"

find $path/$domain -name "wp-config.php" -type f -print0 | xargs -0 sed -i "s/$dbuser/$newdbuser/g"
find $path/$domain -name "wp-config.php" -type f -print0 | xargs -0 sed -i "s/$dbname/$newdbname/g"
find $path/$domain -name "wp-config.php" -type f -print0 | xargs -0 sed -i "s/$ESCdbpass/$newdbpass/g"
find $path/$domain -name "wp-config.php" -type f -print0 | xargs -0 sed -i "s/\r//g"
find $path/$domain -type d -exec chmod 755 {} \;
find $path/$domain -type f -exec chmod 644 {} \;

ssh -C root@$IP mysqldump -u$dbuser --password="$dbpass" $dbname | mysql -u $newdbuser --password=$newdbpass -D $newdbname
echo $domain >> output.csv
done
echo "Completed"
echo -e "\e[1;31;44m *** \e[37mEnding Domain Migration script:`date` \e[31m***  \e[0m"