Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p
sakila > sakila2013.sql Which two commands will restore the sakila database without
interfering with other running database?
A.
Mysql> USE sakila; LOAD DATA INFILE ‘sakila2013.sql’;
B.
Shell> mysql –u root –p sakila sakila2013.sql
C.
Shell> mysql import –u root –p sakila sakila2013.sql
D.
Shell> mysql –u root -p –e ‘use sakila; source sakila2013.sql’
E.
Shell> mysql –u root –p –silent < sakila2013.sql
B,D
B is missing a pipe for the restore
should be:
B. Shell> mysql –u root –p sakila < sakila2013.sql
Still B.D
Agree Kenny B D
D E is the right answer
And B & D . In exam, Option B is provided as below
mysql –u root –p sakila < sakila2013.sql