MySQL Backup script

Just for a future reference, mysql backup script:

#!bat
@REM echo off
@REM this script creates a backup of all the mysql databases in the designated directory.
@REM Please provide day of a week as a parameter

set file=d:\Mysql_backup\%1%_backup
mysqldump -u backuper --all-databases > %file%
7z a %file%.zip %file%
del %file%

-u backuper specifies the mysql user. This user must have a read access to all the databases. Provide a day of the week as a first argument.