Database Backup
The Database Backup feature allows Super Admins to create, download, and manage backups of the entire eSchool database to protect school data from loss.
Overview
| Item | Description |
|---|---|
| Purpose | Back up and restore eSchool database |
| Required Role | Super Admin only |
| Route | /database-backup |
Super Admin Access Only. This feature is restricted to Super Admin accounts. School Admins cannot access database backup functionality.
Creating a Backup
Log in as Super Admin and navigate to Database Backup from the sidebar
Click Create Backup to initiate a new database snapshot
Wait for the backup process to complete (this may take a few moments depending on database size)
Once complete, the backup will appear in the backup list with a timestamp
Downloading a Backup
On the Database Backup page, locate the backup you wish to download
Click the Download button next to the backup file
Save the backup file in a secure, off-site location
Best Practices
We strongly recommend creating regular backups, especially before:
- Performing system updates or upgrades
- Running bulk data imports
- Making major configuration changes
| Recommendation | Details |
|---|---|
| Frequency | At minimum weekly, ideally daily for active schools |
| Storage | Store copies in at least 2 different locations |
| Testing | Periodically test restoring from a backup to verify integrity |
| Retention | Keep at least 3-4 recent backups before deleting older ones |
Backup File Format
Database backups are typically exported as SQL files (.sql) which contain all the data and schema for the eSchool system. These files can be used to restore the database if needed.