🗄️ Database Backups
The Database Backup & Restore feature ensures your restaurant data is always safe and recoverable. Whether you’re migrating servers, applying updates, or protecting against accidental loss, backups give you confidence and continuity — with minimal effort.
🔐 Why Use Database Backups?
✅ Data Protection – Safeguard essential records from corruption or accidental deletion.
🔄 Easy Recovery – Quickly restore your system to a previous working state.
💼 Business Continuity – Avoid disruptions and maintain smooth daily operations.
🧠 Peace of Mind – Make changes knowing your data is secure and backed up.
⚙️ How to Use
📤 Creating a Backup
Go to > Database Backups
Click “Generate Backup.”
A .sql backup file will be created and saved securely on your server
⚠️ Note: Backup files are not downloadable from the browser for security reasons.
You’ll need server access (FTP or control panel) to retrieve the files manually.
📥 Restoring a Backup
Navigate to > Database Backups
Locate the desired backup file
Click “Restore.”
Confirm the restoration – your current database will be overwritten
⚠️ Warning: This action is irreversible. Always double-check before proceeding with a restore.
🧹 Managing Backups
Old backups can be safely deleted to conserve server space
It’s recommended to retain the latest 3–5 backups for redundancy
Use the timestamped file names to identify versions (e.g., backup-2025-07-23.sql)
🔄 Backup Best Practices
Task
Recommendation
Backup Frequency
Weekly backups (daily for high-activity environments)
Before Updates
Always create a fresh backup before updating the system
Storage
Keep backup copies on server or secure cloud storage
File Naming
Use consistent naming patterns for easy tracking
🛠️ Troubleshooting
Restore Fails?
→ Check if the backup file is valid and if the server has proper write permissions.
Can’t Create Backup?
→ Make sure there’s enough storage space and correct file permissions on the server.
Missing Data After Restore?
→ Confirm you selected the correct backup file version.
Last updated