Monday, 22 May 2017

What is mysqldump ?

Mysqldump is a part of the MySQL relational database package that allows you to "dump" a database, or a collection of databases, for backup or transferral 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 

No comments:

Post a Comment