Skip to content

A CLI tool for backing up and restoring multiple types of databases (MySQL, PostgreSQL, MongoDB, SQLite).

Notifications You must be signed in to change notification settings

SamMintah/database-backup-utility

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Database Backup Utility
A Node.js CLI tool for backing up and restoring multiple types of databases (MySQL, PostgreSQL, MongoDB, SQLite). Supports full, incremental, and differential backups, with options for local and cloud storage (AWS S3, Google Cloud Storage, Azure Blob). Includes automatic backup scheduling, compression, and logging of activities.


Features:

  • Supports MySQL, PostgreSQL, MongoDB, SQLite
  • Full, incremental, and differential backups
  • Backup compression to save storage space
  • Local and cloud storage options
  • Backup scheduling and logging
  • Easy restoration with selective restore options
  • Notifications via Slack

Usage:

To see the available commands and options, run:

npm run help

> [email protected] help
> ts-node ./src/cli.ts

Usage: db-backup-utility [command] [options]

CLI tool to backup, restore, and schedule database backups

Options:
  -V, --version       output the version number
  -h, --help          display help for command

Commands:
  configure           Run the configuration wizard for database setup
  backup [options]    Backs up the database
  restore [options]   Restores the database from a backup file or cloud storage
  schedule [options]  Schedules automatic backups using a cron expression
  list [options]      List existing backups
  help [command]      display help for command

Tech Stack:

  • Node.js
  • Commander.js (CLI framework)
  • MySQL, PostgreSQL, MongoDB, SQLite
  • Cloud Storage: AWS S3, Google Cloud Storage, Azure Blob
  • Compression: zlib
  • Logging: Winston

Screenshot 2024-09-23 at 6 38 51 PM

About

A CLI tool for backing up and restoring multiple types of databases (MySQL, PostgreSQL, MongoDB, SQLite).

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published