mysqlimport — A Data Import Program Ignore errors. For example, if a table for a text file does not exist, continue processing any remaining files. Without  --force ,  mysqlimport  exits if a table does not exist. Request from the server the public key required for RSA key pair-based password exchange. This option applies to clients that authenticate with the  caching_sha2_password  authentication plugin. For that plugin, the server does not send the public key unless requested. This option is ignored for accounts that do not authenticate with that plugin. It is also ignored if RSA-based password exchange is not used, as is the case when the client connects to the server using a secure connection. If  --server-public-key-path= file_name  is given and specifies a valid public key file, it takes precedence over  --get-server-public-key . For information about the  caching_sha2_password  plugin, see Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . Import data to the MySQL server on the given host. The default host is  localhost . See the description for the  --replace  option. Ignore the first  N  lines of the data file. This option has the same meaning as the corresponding clause for  LOAD DATA . For example, to import Windows files that have lines terminated with carriage return/linefeed pairs, use  --lines- terminated-by="\r
" . (You might have to double the backslashes, depending on the escaping conventions of your command interpreter.) See Section 13.2.7, “LOAD DATA Statement” . By default, files are read by the server on the server host. With this option,  mysqlimport  reads input files locally on the client host. Successful use of  LOCAL  load operations within  mysqlimport  also requires that the server permits local loading; see Section 6.1.6, “Security Considerations for LOAD DATA LOCAL” Lock  all  tables for writing before processing any text files. This ensures that all tables are synchronized on the server. Read options from the named login path in the  .mylogin.cnf  login path file. A “login path”  is an option group containing options that specify which MySQL server to connect to and which account to 507 • --login-path= name • --lock-tables ,  -l • --local ,  -L • --lines-terminated-by=... • --ignore-lines= N • --ignore ,  -i • --host= host_name ,  -h  host_name • --get-server-public-key • --force ,  -f