Targeted Restoration of Employees Table in HRDB

Restore a Specific Table from Backup

Write a MySQL command to restore only the "Employees" table in the "HRDB" database from a backup file named "Employees_backup.sql".

Solution:

# This command restores the Employees table in the HRDB database from a backup file
# mysql -u root -p specifies the root user and prompts for a password
# < redirects the contents of Employees_backup.sql into the HRDB database
mysql -u root -p HRDB < Employees_backup.sql

Explanation:

• Purpose of the Query:
• To restore a single table from its backup file.
• Demonstrates targeted recovery using the mysql client.
• Key Components:
• Directs the restoration to the HRDB database where the "Employees" table resides.
• Real-World Application:
• Useful when only one table has been corrupted or lost, avoiding a full database restore.

Notes:

• Verify that the target table is empty or drop the existing table before restoration if necessary.
• Review the backup file for consistency.

For more Practice: Solve these Related Problems:

• Write a command to restore the "Employees" table in the "HRDB" database from a backup file while archiving existing data.
• Write a command to restore the "Orders" table from the "SalesDB" backup file, replacing only the table structure.
• Write a command to restore the "Products" table from a backup file while preserving all current indexes.
• Write a command to restore the "Customers" table from a backup file and output a detailed restoration log.

Go to:

• MySQL Backup and Restore Techniques Exercises Home. ↩
• MySQL Exercises Home ↩

PREV : Restore a Specific Table from Backup.
NEXT : Backup Stored Procedures and Triggers.

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