Skip to content

Implement automatic db backup and restore #26

@DrasticCoder

Description

@DrasticCoder

Description:

I intend to introduce an automatic midnight backup feature to enhance data security while acknowledging the potential drawback of data redundancy. This feature will utilize a cron job to execute the backup and restore processes, ensuring that our server's database is backed up every night and the backup is subsequently restored to a remote database.


Details:
The task involves the following key aspects:

Scheduled Backup: Implement a cron job that runs every midnight to perform a database backup of the server's data. This scheduled task will provide a regular and consistent backup process.

Data Redundancy: Recognize the potential drawback of data redundancy, which is inherent in this process. Redundancy can be managed and documented as part of the project.

Remote Database Restore: After the backup process is completed, restore the backup data to a remote database. This ensures that data security is maintained on both the server and the remote database.

Error Handling and Logging: Implement error handling and logging mechanisms to report and document any issues that may occur during the backup and restore operations.

Configuration Options: Provide options for configuring the backup and restore directories, as well as scheduling the cron job.

Screenshots:

Screenshot from 2023-10-23 20-26-04

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions