MyDumper is a pair of command-line utilities for fast logical backup and restoration of MySQL-compatible databases. MyDumper performs the export side of the operation, while MyLoader reconstructs the databases from the generated dump.
The project is designed around parallelism. Large databases and tables can be split into independent chunks and processed by multiple worker threads, avoiding the single-threaded bottleneck associated with simpler logical dump tools. This makes it particularly useful when backup windows are short or restoration speed is an important part of disaster-recovery planning.
This is free and open source software.
Key Features
- Runs multiple dump threads concurrently to increase export throughput.
- MyLoader restores dump contents in parallel using independently configurable worker threads.
- Splits large tables into chunks so several workers can process the same table concurrently.
- Supports consistent backup strategies intended to minimise data inconsistency during active workloads.
- Can dump individual databases, selected tables or larger groups of database objects.
- Supports configurable compression for generated dump data.
- Offers streaming workflows for moving dump output through external processing pipelines.
- Can invoke external commands against generated files for additional processing.
- Includes filters for selecting or excluding schemas and tables.
- Provides specialised planning for dividing very large tables with string primary keys.
- Can tune chunk targets and planning limits for unusually large or skewed datasets.
- Backs up routines, events and triggers alongside table data where requested.
- Uses configuration files to share connection and behaviour settings across repeated operations.
- Provides controls for restore-time index optimisation and server session variables.
Website: github.com/mydumper/mydumper
Support:
Developer: MyDumper developers
License: GNU General Public License v3.0
MyDumper is written in C. Learn C with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.