v3.4.0 StableLocal-First Native MySQL Client

Streaming Import/Export & Large SQL Transfer | VloamDb Manual

Production-ready database migration tools. Streaming disk I/O prevents memory bloat, with live progress bars and read-only safety locks.

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.

1

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.

2

Complete DDL & Data Dumps

Generated SQL files contain complete table schemas (CREATE TABLE with keys, indexes, and engine parameters) alongside data INSERT statements.

3

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:

🚫Production Read-Only Interception

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.

1

Smart Statement Splitting

Splits standard statements cleanly, executing in sequence while tallying completed statement counters.

2

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.