shell filename with date

#!/bin/bash
cd /var/www/backup/
d=$(date +"%Y_%m_%d")
mysqldump --opt -udbuser -pdbpassword dbname | gzip -c -9 > site.ru_$d.sql.gz