Query to take partial backup in MYSQL
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 &gt; [dump_filename]
-- Example, please note (NO SPACE between -p and your password)
mysqldump -u root -pmypass -A &gt; full_dumb.sql

-- Dump single database
mysqldump -u [username] -p[user_password] [database_name] &gt; [dump_filename]
-- Example
mysqldump -u root -pmypass dbshopping &gt; 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...