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?（）
- AIt exports tables with the most indexes first to assist with import speeds
- BIt ensures that unique indexes have no conflicts when the data is dumped
- CIt orders by primary key to assist in speeding up importing to InnoDB tables
- DIt must be specified so index data is dumped correctly when –on-create-info is used