This project demonstrates Backup & Restore phases in two popular relational databases:
- Phase 1: PostgreSQL – User management, role privileges, backup/restore
- Phase 2: MySQL – Data recovery, indexing, storage engine check, automation
The repository includes:
- Setup instructions (PostgreSQL & MySQL on WSL)
- SQL files for each exercise
- Bash scripts for automation
- Screenshots placeholders (to be added after running the tasks)
│── README.md # Main documentation
│
├── postgresql/ # Phase 1 (Backup & Restore - PostgreSQL)
│ ├── setup/
│ │ ├── postgres-setup.sh # Lab setup file (download/modify)
│ │ └── wsl-setup.md # Guide for running PostgreSQL on WSL
│ ├── tasks/
│ │ ├── tasks.sql # SQL commands
│ └── screenshots/ # screenshot guide
│
│
├── mysql/ # Phase 2 (Backup & Restore - MySQL)
│ ├── setup/
│ │ ├── billing.sql #Restore file
│ │ └── wsl-setup.md # Guide for running MySQL on WSL
│ ├── tasks/
│ │ ├── tasks.sql # SQL commands for Exercises
│ │ └── mybackup.sh # Bash script for automation
│ └── screenshots/ # screenshot guide
│
└── LICENSE (optional)