Database Administration Project

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)

📂 Project Repo Structure

│── 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)