Question

Which option is used in ‘mysqldump’ 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 during an interview for a job.

My question is based upon Checking and Repairing Database Tables in section Database Maintenance, Backups and Replication of MySQL

Answer 1

Correct option is (b) –new-storage-engine

The best I can explain: 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.