Import delimited text with mysqlimport

bash

mysqlimport -u root -p --local --fields-terminated-by=, app_db users.csv

Explanation

`mysqlimport` is a wrapper around `LOAD DATA` semantics.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing imports, exports, and mysql shell utilities

Write rows to a server-side file.

Open In sheetsqlsame section

Import delimited files efficiently.

Open In sheetsqlsame section

Use MySQL Shell utilities for scalable dumps.

Open In sheetbashsame section

Restore a dump created by MySQL Shell utilities.

Open In sheetbashsame section

Export schema and data from one database.

Export a single table only.