1Z0-873 · Question #72
mysqldump can be instructed to include commands to drop and recreate tables before trying to create or load data.
The correct answer is A. True. --add-drop-table Instructs mysqldump to precede the dump output for each table with a DROP TABLE statement that drops the table. This option ensures that when you reload the dump output, the reload operation removes any existing copy of the table before re-creating it.
Question
mysqldump can be instructed to include commands to drop and recreate tables before trying to create or load data.
Options
- ATrue
- BFalse
How the community answered
(20 responses)- A75% (15)
- B25% (5)
Explanation
--add-drop-table Instructs mysqldump to precede the dump output for each table with a DROP TABLE statement that drops the table. This option ensures that when you reload the dump output, the reload operation removes any existing copy of the table before re-creating it.
Topics
Community Discussion
No community discussion yet for this question.