Fehlerhafte löschen
cd /var/spool/exim4/input
rm -rf `grep "SMTP error from remote mail server after RCPT" *| cut -f1 -d":" `
1 update mail_adressen set domain= substring(adresse ,locate('@',adresse)+1) ;
2
3 select distinct(domain) from mail_adressen order by domain ;
4
5
6 set @n=0 ;SELECT @n := @n+1 as id , adresse domain,toplevel,partei,rubrik,privat, name,vorname,lastsent,valid,blocked,count INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ';'from mail_adressen ;
7
8 LOAD DATA INFILE 'data.txt' INTO TABLE mail_adressen FIELDS TERMINATED BY ';' ;
durch wilde, hemmungslose importieren haben sich doch einige Geister eingeschlichen 
Nacharbeit!
1 select id,adresse,domain from mail_adressen order by adresse limit 80;
grep "X-Failed-Recipients" * | cut -f3 -d":" >/root/SerienMail/bad.txt
rm -rf `grep "X-Failed-Recipients" * | cut -f1 -d":" `
strings retry | grep "SMTP error from remote mail server after RCPT TO" | cut -f2 -d":" |sed 's/<//' |sed 's/>//' | grep "@" | sort |uniq
| /Ablauf /Adressen /Ausbau /Etikette /NachArbeiten /Pflege-der-Daten /email /smtplib /tuning |
Linux/Internet/Mail/Schleuder/NachArbeiten (last modified 2008-11-04 07:00:05)
