mysqlimport - Loading Data from Files

MySQL Tutorials - Herong's Tutorial Examples

∟mysqlimport - Loading Data from Files

This section provides some tutorial examples on how to use mysqlimport tool to load data of to tables on a MySQL server from data files.

What Is mysqlimport? mysqlimport is a tool to load data stored in files into tables. Data should be stored in files as tab delimited values. Data file names without extensions should match table names. The command line syntax of mysqlimport is:

herong> %mysql%\bin\mysqlimport db_name file_1, file_2, ...

For example, I used the following command to load data back into the book table. Remember the data was dumped earlier by the mysqldump command with the --tab option.

herong> type Library\book.txt
1       Java    1
2       C++     1
3       FORTRAN 2


herong> %mysql%\bin\mysqlimport --user=root --password=TopSecret \
   Library Library\book.txt

Library.book: Records: 3  Deleted: 0  Skipped: 0  Warnings: 0

Here is how I verified the import result:

herong> %mysql%\bin\mysql.exe --user=root --password
Enter password: TopSecret

mysql> use Library
Database changed

mysql> select * from book;
+------+---------+-----------+
| ID   | Title   | Author_ID |
+------+---------+-----------+
|    1 | Java    |         1 |
|    2 | C++     |         1 |
|    3 | FORTRAN |         2 |
|    1 | Java    |         1 |
|    2 | C++     |         1 |
|    3 | FORTRAN |         2 |
+------+---------+-----------+
6 rows in set (0.00 sec)