๐Ÿ—„๏ธ 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

  1. Go to > Database Backups

  2. Click โ€œGenerate Backup.โ€

  3. 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

  1. Navigate to > Database Backups

  2. Locate the desired backup file

  3. Click โ€œRestore.โ€

  4. 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