mysqldump -u root -p db_name > %date%.sql

or

mysqldump -u root -p password db_name > %date%.sql

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/fxRk1YZunjw/12799