MySQL Backup and Recovery :: 1 Backup and Recovery :: 1.4 Using mysqldump for Backups :: 1.4.5 mysqldump Tips :: 1.4.5.4 Dumping Table Definitions and Content Separately
Section Navigation [Toggle]
- 1.4.5 mysqldump Tips
- 1.4.5.1 Making a Copy of a Database
- 1.4.5.2 Copy a Database from one Server to Another
- 1.4.5.3 Dumping Stored Programs
- 1.4.5.4 Dumping Table Definitions and Content Separately
- 1.4.5.5 Using mysqldump to Test for Upgrade Incompatibilities
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 to suppress
CREATE statements from the output, so that
the dump file contains only table data.
For example, to dump table definitions and data separately for
the test database, use these commands:
shell>mysqldump --no-data test > dump-defs.sqlshell>mysqldump --no-create-info test > dump-data.sql
For a definition-only dump, add the
--routines
option to also include stored routine definitions:
shell> mysqldump --no-data --routines test > dump-defs.sql
