po modyfikacji

#!/bin/sh

FROMDATE=`date -d "-1 month -$(($(date +%d)-1)) days" +%Y-%m-%d`
TODATE=`date +%Y-%m-01`

echo "from : "${FROMDATE}
echo "to : "${TODATE}
#mysql --user="$user" --password="$password" --database="$database" --execute="DROP DATABASE $user; CREATE DATABASE $database;"

#prepare:
echo "job_2 table:"
mysql --database="16345594_ha" --execute="select count(*) from job_2 where Data >= '${FROMDATE}' and Data < '${TODATE}' order by Data;"
echo "job_2_backup table:"
mysql --database="16345594_ha" --execute="select count(*) from job_2_backup where Data >= '${FROMDATE}' and Data < '${TODATE}' order by Data;"
mysql --database="16345594_ha" --execute="insert ignore into job_2_backup select * from job_2 where Data >= '${FROMDATE}' and Data < '${TODATE}';"
mysql --database="16345594_ha" --execute="delete from job_2 where Data >= '${FROMDATE}' and Data < '${TODATE}';"
echo "job_2 table:"
mysql --database="16345594_ha" --execute="select count(*) from job_2 where Data >= '${FROMDATE}' and Data < '${TODATE}' order by Data;"
echo "job_2_backup table:"
mysql --database="16345594_ha" --execute="select count(*) from job_2_backup where Data >= '${FROMDATE}' and Data < '${TODATE}' order by Data;"