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.