Bash to extract MySQL bin logs of a database between date range

extract_binlog

#!/bin/bash
MYSQL_BIN_LOG_FOLDER='/var/lib/mysql'
MYSQL_BIN_LOG_FORMAT='.*mysql\-bin.*'

DATABASE_NAME=$1
START_TIMESTAMP=$2
END_TIMESTAMP=$3

echo $DATABASE_NAME
echo $START_TIMESTAMP
echo $END_TIMESTAMP
for FILE_NAME in $(find $MYSQL_BIN_LOG_FOLDER -maxdepth 1 -type f -regex $MYSQL_BIN_LOG_FORMAT -printf "%p\n" | sort -n); do
	echo "mysqlbinlog -d ${DATABASE_NAME} --start-datetime=\"${START_TIMESTAMP}\" --stop-datetime=\"${END_TIMESTAMP}\" ${FILE_NAME}"
	mysqlbinlog -d $DATABASE_NAME --start-datetime="${START_TIMESTAMP}" --stop-datetime="${END_TIMESTAMP}" $FILE_NAME	
done

Example: extract_binlog db_name '2017-01-01 01:00:00' '2017-12-31 23:59:59'