?
In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?
Answer & Solution
Correct Answer:
Option
B
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
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
Join the Discussion
Login to post a comment or share your explanation.
Login