Withdata Software

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

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

Using Withdata DB To File, a JSON lines exporter for MySQL on Windows, MacOS, and Linux, you can export MySQL (MariaDB, Percona) data to JSON lines (JSONL / NDJSON / LDJSON) easily and fast.

Download DBToFile Download DBToFile
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

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.

3. Summary.

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

After exporting, you can view output JSON lines (JSONL / NDJSON / LDJSON) 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.

FAQ

How long does it take to export MySQL to JSONL?
DBToFile works fast. It convert millions of rows within a minute.
Is it safe to export MySQL to JSONL using DBToFile?
Of course! DBToFile export MySQL to JSONL locally, absolutely safe.
Can I export MySQL to JSONL on Linux, Mac OS?
Yes, you can. DBToFile has Linux, Mac OS, and Windows version.
Can I export MySQL to JSONL in command line?
Yes, you can. DBToFile can running in command line, on Linux, Mac OS, and Windows.


More about DBToFileMySQL to JSONL converter