Mysqldump is a part of the mysql relational database package to “dump” a database, or collection of databases, for backup or transfer to another SQL server. The server that imports the databases does not have to be mysql.

The typical way to use mysqldump is one of the following commands:

mysqldump [options] db_name [tables]

mysqldump [options] –databases DB1 [DB2 DB3…]

mysqldump [options] –all-databases

For more information, please see our mysqldump command page.

If you do not name any tables or use the –databases or –all-databases option, entire databases are dumped.

Database, Database terms, MySQL, SQL Server

  • See the mysql command page for further information about the command line version of this command.
  • The official MySQL page.