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> mysqlimport –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
Suggested Answer:BD🗳️
C: If you need to restore a database that already exists, you'll need to use mysqlimport command. The syntax for mysqlimport is as follows: mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql] E: Basic syntax to restore: mysql -u root -p[root_password] [database_name] < dumpfilename.sql Reference: How to Back Up and Restore a MySQL Database
Currently there are no comments in this discussion, be the first to comment!
This section is not available anymore. Please use the main Exam Page.1z0-883 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Comments