Full Database & Selective Table SQL Export
Right-click any database in the sidebar or active tab to open "Export Database". VloamDb generates clean MySQL SQL dumps for the entire database or a specific subset of selected tables via an interactive drawer.
Select All or Individual Tables
The drawer lists all tables in the active schema, supporting one-click Select All, Deselect All, or targeted multi-table selections.
Complete DDL & Data Dumps
Generated SQL files contain complete table schemas (CREATE TABLE with keys, indexes, and engine parameters) alongside data INSERT statements.
Standards-Compliant Header & Footer
Automatically sets charset directives, disables foreign key checks during import, and handles safe transaction boundaries.
Streaming Disk I/O & Cancelability
Traditional Electron database GUIs often load entire query dumps into JavaScript heap memory, causing out-of-memory crashes. VloamDb features a Go goroutine streaming file pipeline engineered for massive tables:
Direct Disk Streaming
Rows are streamed from MySQL wire protocol directly to disk buffers. Exporting multi-gigabyte databases uses under 100MB RAM.
Atomic Write Guard
Writes to an adjacent temporary file and renames atomically upon completion. Existing destination files remain untouched if aborted.
Live Progress & Cancel
Track exported row counters and active table statuses with an instant "Cancel" button that cleans up backend cursors safely.
SQL Script Import & Read-Only Locks
When restoring database dumps into staging or test environments, use the built-in "Import SQL" workflow. VloamDb enforces strict safety and syntax parsing:
If the target connection has Read-Only Protection enabled, the Go service blocks the import at the driver level, refusing to execute batch modifications against production databases.
Smart Statement Splitting
Splits standard statements cleanly, executing in sequence while tallying completed statement counters.
Accurate Error Diagnostics
If a statement encounters a syntax error or constraint conflict, execution halts and reports the exact statement index and MySQL error code.
Result Grid Export: CSV, JSON & SQL
Beyond whole-database dumps, developers frequently export ad-hoc query results. VloamDb data grid supports multiple export formats:
- CSV Format (with Excel UTF-8 BOM): Adheres to RFC 4180 with proper double-quote escapes, rendering seamlessly in Excel and Google Sheets.
- JSON Array Format: Maps rows to keyed JSON objects, ideal for Mock data fixtures and API testing.
- SQL INSERT Batch Generator: Emits clean
INSERT INTO `table` VALUES (...)multi-row statements to seed test environments.