mysqlimport
mysqlimport :
This command used to insert records from a file . It strips any extension from the file name and uses the result to determine the name of the table into which to import the file’s contents. The mysqlimport provides a command-line interface to the LOAD DATA INFILE SQL statement.
Syntax:
mysqlimport -u [uname] -p[pass] [dbname] [file_name1,file_name2, … ]
Example:
mysqlimport -u uname -ppass keyword wordlist.txt,wordlist.sql;
wordlist.txt,wordlist.sql records are imported into a table named “wordlist” in “keyword” database.
