ssh_db_dump
Dump databases over SSH to remote files without modifying data. Supports MySQL, PostgreSQL, MongoDB with optional compression and table selection.
Instructions
Dumps a database to a file on the remote server over SSH; it reads data only and does not modify the database. Supports mysql (using --single-transaction --routines --triggers), postgresql (custom format with --clean --if-exists, restorable via pg_restore), and mongodb. compress defaults to true and gzips the output. The optional tables list applies to MySQL and PostgreSQL only and is ignored for MongoDB.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| server | Yes | Server name | |
| type | Yes | Database type | |
| database | Yes | Database name | |
| outputFile | Yes | Output file path (will be created on remote server) | |
| dbUser | No | Database user | |
| dbPassword | No | Database password | |
| dbHost | No | Database host (default: localhost) | |
| dbPort | No | Database port | |
| compress | No | Compress output with gzip (default: true) | |
| tables | No | Specific tables to dump (MySQL/PostgreSQL only) |