Mysqldump is a utility that comes with MySQL. It can be used to dump a database or a collection of databases for backup or for exporting the data to another SQL server. The dump contains SQL statements to create the table and/or populate the table.
Here are common ways to invoke mysqldump:
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases DB1 [DB2 DB3...]
shell> mysqldump [options] –all-databases
shell>mysqldump –all-databases –master-data=2 > all_databases.sql
If you do not name any tables or use the –databases or –all-databases option, entire databases are dumped.
To get a list of the options your version of mysqldump supports, execute
mysqldump –help
Be First To Comment
Related Post
Leave Your Comments Below