#!/bin/sh
CONF="/store/www/postfixadmin/www/config.inc.php"
SERVER="$(cat $CONF | egrep '(^\$CONF)' | egrep -o "(.*)database_host(.*)=(.*)" | awk 'BEGIN {FS="="} {print $2}' | sed -e "s/['|;| ]//g")"
USER="$(cat $CONF | egrep '(^\$CONF)' | egrep -o "(.*)database_user(.*)=(.*)" | awk 'BEGIN {FS="="} {print $2}' | sed -e "s/['|;| ]//g")"
PASSWORD="$(cat $CONF | egrep '(^\$CONF)' | egrep -o "(.*)database_password(.*)=(.*)" | awk 'BEGIN {FS="="} {print $2}' | sed -e "s/['|;| ]//g")"
DATABASE="$(cat $CONF | egrep '(^\$CONF)' | egrep -o "(.*)database_name(.*)=(.*)" | awk 'BEGIN {FS="="} {print $2}' | sed -e "s/['|;| ]//g")"
DOMINIO="paginegialle.it"
TABELLA="alias mailbox"
QUERY="domain='$DOMINIO'"
for TABLE in $TABELLA
do
mysqldump -u$USER -p$PASSWORD -h$SERVER -n -t $DATABASE $TABLE -w $QUERY > $TABLE.sql
done