gdscpce / gdscpce/hacktober-codesnippet

Implement automatic db backup and restore

Open
#26 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1
Forks
10
PR merge metrics
No merged PRs in 30d

Description

### 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](https://github.com/gdscpce/hacktober-codesnippet/assets/86515544/1441db7b-1f7d-4bb1-a2cf-234524f34f7c)

Contributor guide

Open the contributing guide

Research direction

No files, tests, database engine, or entry points are named; first map the repository's database and scheduling configuration. Done requires a midnight backup and remote restore with configurable locations and schedule, plus error handling and logging, but the issue needs project-specific design before implementation.

Written by the indexing model from the issue text.

Assessment

Domain
backend, databases, devops
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.