MySQL Database Management

Master MySQL database design, queries, joins, and optimization techniques.

intermediate Databases 5 hours

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