Database Backups

FaxStore includes a built-in database backup system designed to automatically protect store data without requiring manual intervention.

Table of Contents

Overview

The backup system creates a full backup of the FaxStore database on a scheduled basis and retains these backups for a defined period.

• Backup Frequency: Daily

• Backup Time: 12:00 GMT or 12:00 server time

• Retention Period: 30 days

This ensures that recent data is always available for recovery in the event of data loss, corruption, or unintended changes.

Backup Location

All backups are stored locally on the server in the following directory:

/faxstore/etc/sql-backups

Each backup file is named using a Unix epoch timestamp, representing the exact time the backup was created.

Example

1719835200.sql
1719921600.sql

This format allows backups to be easily sorted and identified chronologically.

How It Works

• A scheduled task automatically triggers the backup process at 12:00 GMT each day.

• The entire FaxStore database is exported and saved as a .sql file.

• Older backups are automatically removed once they exceed the 30-day retention window.

No manual setup is required for this feature, and it runs as part of the core FaxStore system.

Restoring a Backup

To restore a backup, select the desired .sql file from the backup directory and import it into your MySQL database.

A basic example using the MySQL CLI:

mysql -u username -p database_name < /faxstore/etc/sql-backups/1719835200.sql

Notes

• Backups are stored locally on the same server as FaxStore.

• It is recommended to periodically copy backups to an external location for additional redundancy.

• Ensure sufficient disk space is available to accommodate up to 30 days of backups.