Database Management MySQL Subjective
Oct 01, 2025

Explain MySQL backup and recovery strategies.

Detailed Explanation

Backup types:
Logical: mysqldump (SQL statements)
Physical: File system copy
Hot: Online backup (MySQL Enterprise)
Cold: Offline backup

Example:
mysqldump -u root -p database_name > backup.sql
mysql -u root -p database_name < backup.sql

Point-in-time recovery:
Use binary logs to recover to specific time.

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback