1. delete unused domains A good start is to go through apache2 config:

 grep ^Use domains.conf |cut -f4 -d\ |sort >/tmp/d.txt

for a small number of domains, it is pretty quick and 100% correct going through the list manualy

   domains=`grep ^Use domains.conf |cut -f4 -d\ | xargs`
   for i in $domains; do
      host $d
      read yn
      if [ "${yn}foo" != 'nfoo' ]; then
          echo $d >>/tmp/ws2.alive

Or automaticaly:

for i in `cat /tmp/d.txt|xargs`; do
 host $i |grep 146.255 -q || echo $i >>/tmp/dead.tmp;
sort /tmp/dead.tmp >/tmp/deads.txt
  diff -u /tmp/ds.txt /tmp/dead2.txt |sed -n 's/^-\(.*\)/\1/p' >/tmp/alive.txt

Generate the domains again

 diff -u /tmp/ws2.alive /tmp/ws.dead | sed -n 's/^-\(.\)\(.*\)/Use VhostCGI \1 \1\2/p'

Save this list for later editing the DNS.

2. remove dead databases

cat /tmp/ws2.alive |tr -s . _ |sort >/tmp/db.alive
ls -1 /var/lib/mysql/ > /tmp/db.old
domains =`diff -u db.old db.alive | grep ^-|tr -s _ .|cut -f2 -d-`
for i in $domains; do host $i|grep -q && echo $i; done >> /tmp/db.alive
   sort db.alive >db2.alive
These are dead 
   diff -u db.old db2.alive | sed -n 's/^-\(.*\)/drop database \1;/p'

Change DNS a) those who has dns at us

   cd /mnt/swraid/conf/bind/domains_master
   sed -i 's/' *

b) the rest - contact by email

xhost/migration-web.txt · Last modified: 2020/02/17 08:31 by admin