Explanation of mysqldump parameters in MySQL

Source: Internet
Author: User

Utility to dump a database or many databases for backup or to transfer data to another SQL Server. Dumping will include SQL statements that create tables or enrich tables.

shell> mysqldump [OPTIONS] database [tables]

If you do not give any tables, the entire database will be dumped.

By executing mysqldump--help, you can get the options table supported by your mysqldump version.

Note that if you run mysqldump without--quick or--opt option, mysqldump will load the entire result set into memory before dumping results, if you are dumping a large database, it will probably be a problem.

Mysqldump supports the following options:

在每个表倾倒之前增加LOCK TABLES并且之后UNLOCK TABLE。(为了使得更快地插入到MySQL)。
在每个create语句之前增加一个drop table。
-c, --complete-insert
-C, --compress
-e, --extended-insert
-#, --debug[=option_string]

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.