In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?

Solution (By Examveda Team)

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