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.