What effect does the – order-by-primary argument have on the mysqldump command?

You have table ‘apps’,’userdata’ on server that uses MyISAM storage engine. You want to
transfer this data to server but use InnoDB engine instead. You execute the following
commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps
userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e ‘ALTER TABLE
‘apps’,’userdata’ ENGINE=InnoDB;’ Shell> mysqldump –u root –p –h server –no-create-info
–order-by-primary apps userdata | mysql –u root –p apps What effect does the –
order-by-primary argument have on the mysqldump command?

A.
It ensures that unique indexes have no conflicts when the data is dumped.

B.
It orders by primary key to assist in speeding up importing to InnoDB tables.

C.
It exports tables with the most indexes first to assist with import speeds.

D.
It orders by primary key to assist in speeding up importing to InnoDB tables.

Explanation: