mysqlpump — A Database Backup Program Read this option file after the global option file but (on Unix) before the user option file. If the file does not exist or is otherwise inaccessible, an error occurs. If  file_name  is not an absolute path name, it is interpreted relative to the current directory. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Use only the given option file. If the file does not exist or is otherwise inaccessible, an error occurs. If file_name  is not an absolute path name, it is interpreted relative to the current directory. Exception: Even with  --defaults-file , client programs read  .mylogin.cnf . For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Read not only the usual option groups, but also groups with the usual names and a suffix of  str . For example,  mysqlpump  normally reads the  [client]  and  [mysqlpump]  groups. If this option is given as  --defaults-group-suffix=_other ,  mysqlpump  also reads the  [client_other]  and [mysqlpump_other]  groups. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . In the dump output, defer index creation for each table until after its rows have been loaded. This works for all storage engines, but for  InnoDB  applies only for secondary indexes. This option is enabled by default; use  --skip-defer-table-indexes  to disable it. Include Event Scheduler events for the dumped databases in the output. Event dumping requires the EVENT  privileges for those databases. The output generated by using  --events  contains  CREATE EVENT  statements to create the events. This option is enabled by default; use  --skip-events  to disable it. Do not dump the databases in  db_list , which is a list of one or more comma-separated database names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. Do not dump the databases in  event_list , which is a list of one or more comma-separated event names. Multiple instances of this option are additive. For more information, see mysqlpump Object Selection. 521 • --exclude-events= event_list • --exclude-databases= db_list • --events • --defer-table-indexes • --defaults-group-suffix= str • --defaults-file= file_name