Import CSV into MySQL
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Read Binary File. 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary File Read From File | Read/Write Files from Disk |
Worth a look
- Spreadsheet File (Convert To Spreadsheet): Convert to File / Extract from File
Nodes used (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Read Binary File
n8n-nodes-base.readBinaryFile - Spreadsheet File
n8n-nodes-base.spreadsheetFile - MySQL
n8n-nodes-base.mySql
What it does
This workflow demonstrates how CSV file can be automatically imported into existing MySQL database. !25n8nworkflow.png(fileId:689) Before running the workflow please make sure you have a file on the server: /home/node/.n8n/concerts-2023.csv And the content of the file is the following: Date,Band,ConcertName,Country,City,Location,LocationAddress, 2023-05-28,Ozzy Osbourne,No More Tours 2 - Special Guest: Judas Priest,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-05-08,Elton John,Farewell Yellow Brick Road Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-05-26,Hans Zimmer Live,Europe Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-07-07,Depeche Mode,Memento Mori World Tour 2023,Germany,Berlin,Olympiastadion Berlin,"Olympischer Platz 3, 14053 Berlin-Charlottenburg", The detailed process is explained in the tutorial https://blog.n8n.io/import-csv-into-mysql