Question

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

(c) –clear-storage-engine

(d) –get-storage-engine

The question was asked in quiz.

This intriguing question comes from Copying Databases to Another Server in section Database Maintenance, Backups and Replication of MySQL

Answer 1

The correct answer is (b) –new-storage-engine

For explanation: While using the program ‘mysqldump’ in MySQL to copy databases from server to server, all tables in the destination databases can be directed to use a different storage engine with the –new-storage-engine option.