DEV Community

Julian Li
Julian Li

Posted on

1

Database backup with onedump

Onedump is a CLI tool for database backup. It supports database dump from multiple sources( MySQL or PostgreSQL database) and stores it in your preferred storage (Local, S3, Google Drive or Dropbox). It is easy to use and manage, basically, it is just a simple command with a single configuration.

Motivation

Before I started to implement this tool, I asked myself why I need to create another tool for database backup again. Although there might have had some tools that did a good job with database backup, I rarely found one that fit my needs:

I need a tool to dump MySQL and PostgreSQL databases to different storage with a simple command and a single configuration file. I need this tool not only to be able to dump databases directly via the network (if possible) but also to dump via SSH (if possible).

I want it to be fast to back up databases, concurrently if possible.

I want it to be easy to configure, one configuration file is the goal.

I prefer to store my configuration file in a secure location, ideally with encryption at rest.

The tool

To resolve my own requirements, as shown above, I am glad that I have delivered the tool and run it for the backup of all my side project databases. I will be more joyful if it helps other people who have similar needs. For more details like how to use it, here is the instruction

API Trace View

How I Cut 22.3 Seconds Off an API Call with Sentry

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Read more →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay