Take the 2-minute tour ×
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. It's 100% free, no registration required.
 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

1 Answer 1

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

UPDATE:

-- 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 ...it wrkdout....thanks buddy..!! –  Anto Nov 10 '12 at 6:38
    
@Anto - you're welcome... :) –  rajukoyilandy Nov 10 '12 at 18:25

Your Answer

 
discard

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.