MySql Database backup

[Devendra Yadav]

Hello everyone, i have created one database as student now i want to keep the database backup in my E:// drive for project deployment. I m not getting that where my database is storing.
Plz tell me what should i do for he backup manually not mysql command line. I have used Java as front end for application.

[Atli]

The mysqldump utility can be used to generate MySQL backups. At it's simplest you can just do:

mysqldump -u root -p -R -A > E:\db_backup_file.sql

This will prompt you for the root password, and then dump all your databases into the backup file.

If you don't want to use the command line tool, you can use programs like MySQL Workbench. They have a GUI that allows you to dump your databases.