Selective Backup of Employees Table from HRDB

Backup a Specific Table using mysqldump

Write a MySQL command to back up only the "Employees" table from the "HRDB" database using mysqldump.

Solution:

# This command uses mysqldump to back up only the Employees table from the HRDB database
# -u root specifies the root user, -p prompts for password, and > redirects output to a file
mysqldump -u root -p HRDB Employees > Employees_backup.sql

Explanation:

• Purpose of the Query:
• To export data from a single table rather than the whole database.
• Demonstrates selective table backup using mysqldump.
• Key Components:
• HRDB Employees : Specifies the database and the table to be backed up.
• The rest of the command remains similar to a full backup.
• Real-World Application:
• Useful when only certain critical tables need to be backed up or restored.

Notes:

• Ensure the table name is spelled correctly.
• Regularly back up important tables independently.

For more Practice: Solve these Related Problems:

• Write a command to back up only the "Employees" table from the "HRDB" database including both data and structure.
• Write a command to back up the "Sales" table from the "StoreDB" database while excluding rows older than one year.
• Write a command to back up the "Products" table from the "InventoryDB" database but skip specific columns.
• Write a command to back up the "Customers" table from the "CRM" database and compress the output simultaneously.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous MySQL Exercise: Full Database Backup using mysqldump.
Next MySQL Exercise: Backup all Databases using mysqldump.