mysqlimport — A Data Import Program For more information on making backups, see Section 7.2, “Database Backup Methods” , and Section 7.3, “Example Backup and Recovery Strategy” . mysqldump  does not dump the  performance_schema  or  sys  schema by default. To dump any of these, name them explicitly on the command line. You can also name them with the  --databases  option. For performance_schema , also use the  --skip-lock-tables  option. mysqldump  does not dump the  INFORMATION_SCHEMA  schema. mysqldump  does not dump  InnoDB CREATE TABLESPACE  statements. mysqldump  does not dump the NDB Cluster  ndbinfo  information database. mysqldump  includes statements to recreate the  general_log  and  slow_query_log  tables for dumps of the  mysql  database. Log table contents are not dumped. If you encounter problems backing up views due to insufficient privileges, see Section 25.9, “Restrictions on Views”  for a workaround. The  mysqlimport  client provides a command-line interface to the  LOAD DATA  SQL statement. Most options to  mysqlimport  correspond directly to clauses of  LOAD DATA  syntax. See Section 13.2.7, “LOAD DATA Statement” . Invoke  mysqlimport  like this: For each text file named on the command line,  mysqlimport  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. For example, files named  patient.txt ,  patient.text , and  patient  all would be imported into a table named  patient . mysqlimport  supports the following options, which can be specified on the command line or in the [mysqlimport]  and  [client]  groups of an option file. For information about option files used by MySQL programs, see Section 4.2.2.2, “Using Option Files” . 501 Table 4.15 mysqlimport Options Option Name Description Introduced Deprecated --bind-address Use specified network interface to connect to MySQL Server --columns This option takes a comma-separated list of column names as its value mysqlimport [ options ]  db_name textfile1  [ textfile2  ...] 4.5.5 mysqlimport — A Data Import Program Restrictions •To select the effect of  --opt  except for some features, use the  --skip  option for each feature. To disable extended inserts and memory buffering, use  --opt --skip-extended-insert --skip- quick . (Actually,  --skip-extended-insert --skip-quick  is sufficient because  --opt  is on by default.) •To reverse  --opt  for all features except index disabling and table locking, use  --skip-opt -- disable-keys --lock-tables .