MySql Backup Database with mysqldump

To backup MySql Database from command line.

mysqldump -u user_name -p Database_Name > backup-file.sql

In windows xp, 7, or 8 simply run the above command in CMD. It will place the backup-file.sql in the same direcotry where you run the command from.

for more information look at mysqldump