#!/bin/bash
dat=$(date +%Y%m%d_%H%M)

mysqldump --xml --user=root --password=B@k2 --lock-all-tables --where="sellerId in (select sellerId from users2sellers where userId in (select userId from users where locationPrefix = 'BUC'))" aurora sellers > /home/Exchange/DIANGI/OUT/sellers.xml;
scp /home/Exchange/DIANGI/OUT/sellers.xml root@ks370215.kimsufi.com:"/home/Exchange/DIANGI/OUT/sellers_"$dat".xml"
rm /home/Exchange/DIANGI/OUT/sellers.xml

mysqldump --xml --user=root --password=B@k2 --lock-all-tables --where="programId in (select programId from users_locations2testunit where locationId = 2)" aurora programs > /home/Exchange/DIANGI/OUT/programs.xml;
scp /home/Exchange/DIANGI/OUT/programs.xml root@ks370215.kimsufi.com:"/home/Exchange/DIANGI/OUT/programs_"$dat".xml"
rm /home/Exchange/DIANGI/OUT/programs.xml

mysqldump --xml --user=root --password=B@k2 --lock-all-tables --where="adherentId in (select adherentId from pipes where programId in (SELECT programId from users_locations2testunit where locationId = 2))" aurora adherents > /home/Exchange/DIANGI/OUT/adherents.xml;
scp /home/Exchange/DIANGI/OUT/adherents.xml root@ks370215.kimsufi.com:"/home/Exchange/DIANGI/OUT/adherents_"$dat".xml"
rm /home/Exchange/DIANGI/OUT/adherents.xml

mysqldump --xml --user=root --password=B@k2 --lock-all-tables aurora taclist > /home/Exchange/DIANGI/OUT/taclist.xml;
scp /home/Exchange/DIANGI/OUT/taclist.xml root@ks370215.kimsufi.com:"/home/Exchange/DIANGI/OUT/taclist_"$dat".xml"
rm /home/Exchange/DIANGI/OUT/taclist.xml

exit;