Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sqlWhich 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.sqlC.Shell＞ mysql import –u root –p sakila sakila2013.sqlD.Shell＞ mysql –u root -p –e ‘use sakila; source sakila2013.sql‘E.Shell＞ mysql –u root –p –silent ＜ sakila2013.sql
Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sqlWhich 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
相关考题：
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 appsShell＞ 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 appsWhat effect does the – order-by-primary argument have on the mysqldump command?（）A.It exports tables with the most indexes first to assist with import speedsB.It ensures that unique indexes have no conflicts when the data is dumpedC.It orders by primary key to assist in speeding up importing to InnoDB tablesD.It must be specified so index data is dumped correctly when –on-create-info is used
以下任务计划的含义是什么？（） SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin MAILTO=root 10 4 1,10,22 * * root /root/backup.shA．在每月1、10、22日的4:10执行/root/backup.sh文件B．在10月4号的1、10、22点执行/root/backup.sh文件C．在10年的4月1号，10点-22点执行/root/backup.sh文件D．22点分别执行/root/backup.sh文件
对于数据导入导出，下面说法错误的有：A．mysqldump可以远程导出数据为csv形式B．mysqldump可以将csv形式的数据导入到数据库中C．select into out file导出数据比mysqldump更灵活更快D．select into out file可以多表join进行导数据
同时备份mysql数据库系统中名为xueji1和xueji2的两个数据库到E盘子目录m下名为xj的sql数据库，命令是（)A．mysql -uroot -p --database xueji1 xueji2＞D:msxj.sqlB．mysqldump -uroot -p --database xueji1 xueji2＞D:msxj.sqlC．mysql -uroot -p --databases xueji1 xueji2＞D:msxj.sqlD．mysqldump -uroot -p --databases xueji1 xueji2＞D:msxj.sql