Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
 I tried to take full backup in mysql using enterprise backup by using the command

    mysqlbackup -u root -p --backup-dir=g:\full_bck backup

But I could not take backup of a single database , I tried it using --include database_name.

Please help me to sort out this.

share|improve this question
up vote 3 down vote accepted

The syntax for taking MySQL dump:

-- Dump all databases and all tables (option "-A" is similar to "--all-databases")
mysqldump -u [username] -p[user_password] -A > [dump_filename]
-- Example, please note (NO SPACE between -p and your password)
mysqldump -u root -pmypass -A > full_dumb.sql

-- Dump single database
mysqldump -u [username] -p[user_password] [database_name] > [dump_filename]
-- Example
mysqldump -u root -pmypass dbshopping > dbshopping_dumb.sql


-- MySQL Enterprise Backup Syntax
mysqlbackup --user[username] --password=[user_password] --backup-dir=[backup_directory] --databases=[database_list] backup

-- Example Command
mysqlbackup --user=root --password=mypass --backup-dir=G:\mysql-enterprise-backup-directory --databases=dbshopping backup

I'm not an expert in 'MySQL Enterprise Backup', yet It worked fine for me...

You can also verify backup history and/or progress from 'mysql' database

SELECT * FROM mysql.backup_progress;
SELECT * FROM mysql.backup_history;

Hope this may help you...

share|improve this answer
Thanks for your suggestion , but I am trying to take backup through 'mysql enterprise backup' which is completely different from ordinary dump. – Anto Nov 9 '12 at 5:28
@Anto - Please find the update that I've made, and its working fine for me... :) – rajukoyilandy Nov 9 '12 at 8:52
Yep wrkdout....thanks buddy..!! – Anto Nov 10 '12 at 6:38
@Anto - you're welcome... :) – rajukoyilandy Nov 10 '12 at 18:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.