This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

7.4 Using mysqldump for Backups

7.4.1 Dumping Data in SQL Format with mysqldump
7.4.2 Reloading SQL-Format Backups
7.4.3 Dumping Data in Delimited-Text Format with mysqldump
7.4.4 Reloading Delimited-Text Format Backups
7.4.5 mysqldump Tips

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:

mysqldump produces two types of output, depending on whether the --tab option is given: