1Z0-873 · Question #76
You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance?
The correct answer is B. Yes, provided that --max-allowed-packet is set correctly. If a dump file contains very long INSERT statements, they might exceed the default size of the communications buffer (1MB). You can increase the buffer size for both mysqldump and mysql with the --max-allowed-packet option. The option value may be given in bytes or followed by…
Question
You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance?
Options
- AAlways
- BYes, provided that --max-allowed-packet is set correctly
- CYes, provided that binary logging is turned off during the re-reading of the dump.
- DNo, the new server instance must be the same version as the one which created the dump for
How the community answered
(38 responses)- A3% (1)
- B74% (28)
- C8% (3)
- D16% (6)
Explanation
If a dump file contains very long INSERT statements, they might exceed the default size of the communications buffer (1MB). You can increase the buffer size for both mysqldump and mysql with the --max-allowed-packet option. The option value may be given in bytes or followed by K, M, or G to indicate a size in kilobytes, megabytes, or gigabytes. For example, --max-allowed- packet=32M specifies a size of 32MB. The server also must be run with a --max-allowed-packet value that increases its own communications buffer to be large enough.
Topics
Community Discussion
No community discussion yet for this question.