ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.