Want to import data from CSV file to MySQL via Command Line?
Using FileToDB, a native GUI tool, you can import data from CSV file to MySQL (MariaDB, Percona) via Command Line easily and fast.
Support Windows, Linux, macOS.
Support large CSV files (big than 4GB).
Support multiple CSV file encodings: ANSI, UTF-8, UTF-8BOM, UCS-2LE (Unicode Little Endian), UCS-2BE (Unicode Big Endian), CP1250 (Central European), CP1251 (Cyrillic), CP1252 (Western European), CP1253 (Greek), CP1254 (Turkish ), CP1255 (Hebrew), CP1256 (Arabic), CP1257 (Baltic), CP1258 (Vietnamese), CP437 (United States), CP850 (Western European), CP852 (Central European), CP866 (Cyrillic), CP874 (Thai), CP932 (Japanese), CP936 (Chinese Simplified), CP949 (Korean), CP950 (Chinese Traditional), ISO-8859-1 (Western European), ISO-8859-2 (Central European), ISO-8859-15 (Latin 9), KOI-8 (Cyrillic), Macintosh (Western European).
Here’s how to.
Example of importing CSV to MySQL (MariaDB, Percona)
Example source CSV file
After converting, data in MySQL table
Import data from CSV file to MySQL (MariaDB, Percona)
Please download and install FileToDB, then run it.
Choose MySQL and logon.
Click “Wizard – 1 File To 1 Table” at task dialog.
Select the “CSV” file type.
then show the wizard.
1. Open a CSV file.
2. Select a MySQL table and config fields.
3. Preview data.
4. Import CSV data to MySQL.
View imported data in MySQL table
Save/load session of importing CSV to MySQL (MariaDB, Percona)
You can save/load session to run “CSV to MySQL” conversion repeatly.
1.Save Session.
Click “Save Session” button, then enter a session file name.
click “OK” button.
2.Load Session.
Click the “Open a Saved Session” in task window, select a session file.
then show the wizard form, click a few “Next” to import CSV to MySQL.
Run in command line for importing CSV to MySQL (MariaDB, Percona)
You can run “CSV to MySQL” conversion in command line.
When you save session, you can click “Save & Make Batch File”.
The “Save & Make Batch File” form shows.
Click “OK” button, you’ll create a batch file, in Windows, like this:
C: cd "C:\Users\pansh\AppData\Local\Programs\FileToDB" FileToDB task="C:\Users\pansh\Documents\test.ldr" logfile="C:\Users\pansh\Documents\test.log"
You can run this batch file in command line.
Run as scheduled task for importing CSV to MySQL (MariaDB, Percona)
You can run “CSV to MySQL” conversion automatically at specific time.
On Linux/macOS, you can use Crontab.
For macOS, How to Fix Cron Permission Issues in macOS.
On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.
And then, with scheduled task wizard, step by step.
You’ll see created task listed in scheduled task list.
Download
Here you can download FileToDB, and buy FileToDB.