#!/bin/bash
mysql -e "use interfungi; select 'id', 'idUser', 'hasPhoto','foto1','foto2','latitud','longitud','fechaCorte','especie','agusanamiento','presion' union all (select id, idUser, hasPhoto, concat('https://interfungi.ibercivis.es/uploads/marcadores/',id,'.jpg') as foto1, concat('https://interfungi.ibercivis.es/uploads/marcadores/',id,'_1.jpg') as foto2 , latitud, longitud, fechaCorte, atributo2, atributo3, atributo4 from marcadores) into outfile '/var/lib/mysql-files/volcado.csv'"
d=`date +%d-%m-%Y`
mv /var/lib/mysql-files/volcado.csv /var/www/interfungi/volcados/marcadores_interfungi_$d.csv
chown www-data:www-data /var/www/interfungi/volcados/marcadores_interfungi_$d.csv