Q149
In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?
A.
-next-storage-engine
B.
-new-storage-engine
AnswerC.
-clear-storage-engine
D.
-get-storage-engine
Answer: Option B
Solution
Answer: Option B
Solution:
This question is about the mysqldump command in MySQL, which is used to create a backup of a database. We're looking for the option that lets you change the storage engine used for all tables in the backup.
Let's look at the options:
* Option A: -next-storage-engine: This option isn't related to changing storage engines.
* Option B: -new-storage-engine: This is the correct option! It allows you to specify a new storage engine for all tables in the backup.
* Option C: -clear-storage-engine: This option doesn't exist.
* Option D: -get-storage-engine: This option doesn't exist.
Therefore, the correct answer is Option B: -new-storage-engine