mysqldump can retrieve and dump table contents row by row, or it can retrieve the entire content from a table and buffer it in memory before dumping it. Buffering in memory can be a problem …

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways:

This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format Backups”.

Making Backups with mysqldump The mysqldump program can make backups. It can back up all kinds of tables. (See Section 9.4, “Using mysqldump for Backups”.) For InnoDB tables, it is …

In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the …

The example commands do not include options such as --user and --password for the mysqldump and mysql client programs. You should include such options as necessary to enable client …

The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump …

This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump files, see Section 9.4.4, “Reloading Delimited-Text Format Backups”.

Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql command line.

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways: