How to backup database of mysql using bat

[rajasri]

Today we are going to learn how to backup a database using commands from mysql
The easy way to do this is using a bat file.

open notepad and type
mysqldump --user=root --password=root --lock-all-tables --opt databasename > c:/backup.sql
save this file in your mysql installed bin folder as "restore.bat" now double click it you will find database backup in c:/backup.sql.

Any doubt ask us.

Happy Coding