The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump typically contains SQL statements to create the table, populate it, or both. However,mysqldump can also be used to generate files in CSV, other delimited text, or XML format.
Syntax
There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server—as shown here:
shell>
mysqldump [
options
]db_name
[tbl_name
...]
shell>mysqldump [
options
] --databasesdb_name
...
shell>mysqldump [
options
] --all-databases
To dump entire databases, do not name any tables following db_name
, or use the --databases
or --all-databases
option.
More information
https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html