Mysqldump

Updated: 12/31/2022 by Computer Hope

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 (Structured Query Language) 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
Warning

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

For more information, please see our mysqldump command page.

Database, Database terms, MySQL, SQL Server