Variables in effective windows batch file for deployment?

Question

I've played around quite a bit now, and can't seem to get variables to work in a batch file, when executing commands. So, can anyone tell me if this is possible, and what is wrong with these lines of code:

set THE_DB = myAwesomeDb
set OUTPUT_FILE = .\db\mydb.sql
mysqldump -u root --opt %THE_DB% > %OUTPUT_FILE%

Answer 1

Don't put spaces around the equal symbol.

set THE_DB=myAwesomeDb
set OUTPUT_FILE=.\db\mydb.sql
mysqldump -u root --opt %THE_DB% > %OUTPUT_FILE%