By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

MySql Database backup

P: 1
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.
Dec 28 '11 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 5,058
The mysqldump utility can be used to generate MySQL backups. At it's simplest you can just do:
Expand|Select|Wrap|Line Numbers
  1. 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.
Dec 29 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.