Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use mysql dump correctly". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn how to use mysql dump correctly.

1. If you do not want to block dml and ddl during mysql dump, it is recommended to add-- single-transaction or-- skip-lock-tables

2. It is recommended to add-- databases when exporting a library, because the file exported in this way comes with create database by default.

3. It doesn't matter if opt is enabled by default. Some negative parameters override the options contained in-- opt, such as-- skip-lock-tables overrides-- lock-tables in-- opt.

4. Mysqldump, the longer the time, the more undo will be consumed.

5. If you want to achieve the same effect as expdp of oracle, and the data generated during backup is also backed up, add-- skip-lock-tables, but the risk is that once drop is executed before a table has been backed up, mysqldump will report an error.

6. Use-- master-data or-- lock-all-tables carefully, otherwise mysqldump backup will wait all the time once the database has a lock.

At this point, I believe you have a deeper understanding of "how to use mysql dump correctly". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.