content_image/813458.jpg
For more information on making backups, see Section 7.2, “Database Backup Methods” , and Section 7.3, “Example Backup and Recovery Strategy” . 

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

## Restrictions 

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. 

## 4.5.5 mysqlimport — A Data Import Program 

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: 

mysqlimport [ options ] db_name textfile1  [ textfile2  ...] 

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

<img src='content_image/813458.jpg'>

