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:
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.
