mysqldump — A Database Backup Program advance. For restore times measured in hours, you might prefer an alternative backup and restore solution, such as MySQL Enterprise Backup for  InnoDB -only and mixed-use databases. Performance is also affected by the transactional options, primarily for the dump operation. Add  ANALYZE TABLE  statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded. This option is disabled by default because histogram generation for large tables can take a long time. For each table, surround the  INSERT  statements with  /*!40000 ALTER TABLE  tbl_name  DISABLE KEYS */;  and  /*!40000 ALTER TABLE  tbl_name  ENABLE KEYS */;  statements. This makes loading the dump file faster because the indexes are created after all rows are inserted. This option is effective only for nonunique indexes of  MyISAM  tables. Write  INSERT  statements using multiple-row syntax that includes several  VALUES  lists. This results in a smaller dump file and speeds up inserts when the file is reloaded. Write  INSERT IGNORE  statements rather than  INSERT  statements. The maximum size of the buffer for client/server communication. The default is 24MB, the maximum is 1GB. The initial size of the buffer for client/server communication. When creating multiple-row  INSERT statements (as with the  --extended-insert  or  --opt  option),  mysqldump  creates rows up to --net-buffer-length  bytes long. If you increase this variable, ensure that the MySQL server net_buffer_length  system variable has a value at least this large. Enable large tables to be dumped by setting  --max-allowed-packet  to its maximum value and network read and write timeouts to a large value. This option is enabled by default. To disable it, use  -- skip-network-timeout . This option, enabled by default, is shorthand for the combination of  --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set- charset . It gives a fast dump operation and produces a dump file that can be reloaded into a MySQL server quickly. Because the  --opt  option is enabled by default, you only specify its converse, the  --skip-opt  to turn off several default settings. See the discussion of  mysqldump  option groups for information about selectively enabling or disabling a subset of the options affected by  --opt . 497 • --quick ,  -q • --opt • --network-timeout ,  -M • --net-buffer-length= value • --max-allowed-packet= value • --insert-ignore • --extended-insert ,  -e • --disable-keys ,  -K • --column-statistics