Variable for mysqldump

[Doug Hairfield]

I am trying to run mysqldump in a bash file and I want to name the output of the file with todays date.

#!/bin/bash

date=$(date +%m_%d_%y)

mysqldump --add-drop-table etrials_dev > $date.sql

But I am getting:

mysqldump: ERROR: unknown variable 'local-infile=1'

Any ideas?