Export data from MySQL table to JSON Lines (JSONL / NDJSON / LDJSON)

by

Want to export data from MySQL table to JSON lines (JSONL / NDJSON / LDJSON)?

Using Withdata DBToFile, a JSON lines exporter for MySQL, you can export MySQL (MariaDB, Percona) data to JSON lines (JSONL / NDJSON / LDJSON) easily and fast.

Download DBToFile Download DBToFile

Export data from MySQL (MariaDB, Percona) table to JSON lines (JSONL / NDJSON / LDJSON)

Login to MySQL -> Choose MySQL table -> Set JSON lines file options -> Export MySQL to JSON lines (JSONL / NDJSON / LDJSON)

Choose MySQL and logon.

export MySQL  (MariaDB, Percona) table to JSONL file - Choose MySQL and logon

“Export From Table” for “MySQL to JSON lines (JSONL / NDJSON / LDJSON)”.

Export data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - task window

Select JSON file type.

Export data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - select JSON file type

1. Choose MySQL (MariaDB, Percona) table.

Unload data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - select table

2. Set JSON lines (JSONL / NDJSON / LDJSON) file options.

Extract data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - enter file name

3. Summary.

Convert data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - summary

4. Export MySQL (MariaDB, Percona) data to JSON lines (JSONL / NDJSON / LDJSON) table.

Dump data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - export

After exporting, you can view output JSON lines (JSONL / NDJSON / LDJSON) file.

Export data from MySQL  (MariaDB, Percona) Table To JSON lines (JSONL / NDJSON / LDJSON) - view JSON lines file

Export MySQL to JSON lines (JSONL / NDJSON / LDJSON) in command line

Save “MySQL to JSON lines” session, then you can:

Set scheduled tasks for exporting MySQL to JSON lines (JSONL / NDJSON / LDJSON)

You can schedule and automate this “MySQL to JSON lines” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.


More about DBToFile – MySQL to JSON lines (JSONL / NDJSON / LDJSON) converter

Download DBToFile for 30-day free trialDownload DBToFile