Backup MySQL Database using command line in Windows

Say you get a request to take backup of Test1234 .

Run cmd change directory & run following command.

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p Test1234 > C:/Users/admin/Desktop

/Test1234.sql

Enter password: ****