#!/bin/sh

cd /var/scripts/fullbase/export

rm -f *.gz

echo "export offresvip"
mysql -pSQL1281 -uroot --host=ns220404.ovh.net offresvip-v2 < offresvip.sql | sed -e's/\t/;/g' > offresvip.csv
gzip offresvip.csv

echo "export kalifoo"
mysql -pSQL1281 -uroot --host=ns220404.ovh.net kalifoo < kalifoo.sql | sed -e's/\t/;/g' > kalifoo.csv
gzip kalifoo.csv

echo "export optineo"
mysql -pSQL1281 -uroot --host=ns220404.ovh.net optineo < optineo.sql | sed -e's/\t/;/g' > optineo.csv
gzip optineo.csv

echo "export vipconcours"
mysql -pSQL1281 -uroot --host=ns220404.ovh.net vip-concours_201103 < vipconcours.sql | sed -e's/\t/;/g' > vipconcours.csv
gzip vipconcours.csv