MySQL客户端程序mysqldump的作用是() A、备份数据库B、创建数据库C、启动MySQL服务器D、删除数据库
MySQL客户端程序mysqldump的作用是()
A、备份数据库
B、创建数据库
C、启动MySQL服务器
D、删除数据库
相关考题：
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
备份mysql数据库（名为xueji）中所有内容到D盘子目录ms下的数据库（名为xj）的命令是（)A．mysql -uroot -p xueji＜D:msxj.sqlB．mysqldump -uroot -p xueji＜D:msxj.sqlC．mysql -uroot -p xueji＞D:msxj.sqlD．mysqldump -uroot -p xueji＞D:msxj.sql
同时备份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