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