Chapter 11: Backup and Recovery
Chapter 11 of 15
Chapter 11: Backup and Recovery
11.1 Backup Methods
Regular backups protect against data loss.
Backup Types:
- Full Backup: Complete database copy
- Incremental Backup: Only changed data
- Logical Backup: SQL dump (mysqldump)
- Physical Backup: Raw file copy
11.2 Using mysqldump
-- Backup single database
mysqldump -u root -p database_name > backup.sql
-- Backup all databases
mysqldump -u root -p --all-databases > all_backup.sql
-- Restore from backup
mysql -u root -p database_name < backup.sql