Overview
DumpSync is a simple yet powerful tool designed for dumping and restoring MySQL databases. It can be utilized for backup and restore operations or for transferring a database between different servers.
Overview
DumpSync automates the process of creating dumps of a MySQL database at configurable time intervals. The generated dump files are saved in a user-specified directory, making it easy to manage backups. The tool offers flexibility through configuration options, which can be set via environment variables or command-line arguments, accommodating various usage scenarios.
Key Features
Some of the key features of DumpSync include:
- Automated Backups: Schedule regular database dumps at configurable intervals.
- Flexible Configuration: Easily configure settings using environment variables or command-line arguments.
- Simple Restoration: Quickly restore your database from previously created dump files.
- Cross-Server Transfers: Seamlessly transfer databases between different MySQL servers.
- XSS Scanner: Scan for XSS vulnerabilities in tables to enhance security.
- XSS Report: Generate a detailed report of XSS vulnerabilities found in the database.
- Share: Share your dump or scan results with others.
- Schema: Generate a schema file for the database.
- Encryption: Encrypt your dump files for added security.
- Compression: Compress your dump files to save disk space.
- Checksum: Verify the integrity of your dump files using checksums.
- PDF Report: Generate PDF reports for your dump files and your settings.
- Truncate: Truncate tables to remove all data from the specified table.
- Visual: Visualize the table structure of a database.
- Pull: Pull the latest changes from a remote database to your local environment.
- History: View the history of actions performed by the DumpSync tool.
- Skip Matching: Use patterns to exclude specific tables or lines during restore operations.
- Lock tables: Lock tables during dump operations to ensure data consistency.