7.4.4 Reloading Delimited-Text Format Backups

For backups produced with mysqldump --tab,
each table is represented in the output directory by an
.sql file containing the
CREATE TABLE statement for the
table, and a .txt file containing the table
data. To reload a table, first change location into the output
directory. Then process the .sql file with
mysql to create an empty table and process
the .txt file to load the data into the
table:

If you used any data-formatting options with
mysqldump when you initially dumped the
table, you must use the same options with
mysqlimport or
LOAD DATA
INFILE to ensure proper interpretation of the data
file contents: