Name

msqldump

Synopsis

msqldump [options] database[table]

Outputs the contents of the given database (or table within a database) as a series of ASCII SQL commands.

Options

-c

Output complete INSERT statements.

-f file

Use an alternate configuration file.

-h hostname

Connect to a database server on a remote host.

-t

Dump only the table creation statements; do not dump the data.

-w statement

Use an SQL WHERE clause to limit the data outputted.

-v

Display status information while dumping the data.

Get MySQL and mSQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.