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?

Question

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?

Accepted Answer

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

Answer

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

Answer

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

Answer

D. It must be specified so index data is dumped correctly when on-create-info is used.

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…

Question

Options

How the community answered

Community Discussion