Assume you created a backup of the world database by the following statement. shell> mysqldump --opt world > dump.sql How can you import the data from this dumped file into the test database?

The correct answer is A. shell> mysql test < dump.sql C. mysql> USE test;mysql> SOURCE dump.sql. To reload an SQL-format dump file produced by mysqldump, process it with mysql. For example, you might have made a copy of the Country table in the world database with this command: shell> mysqldump world Country > dump.sql To reload the file later, use mysql: shell> mysql…

Backup and Recovery

Question

Options

Ashell> mysql test < dump.sql
Bshell> mysqladmin recover test dump.sql
Cmysql> USE test;mysql> SOURCE dump.sql;
Dmysql> RECOVER test dump.sql;

How the community answered

(44 responses)

A
84% (37)
B
7% (3)
D
9% (4)

Explanation

To reload an SQL-format dump file produced by mysqldump, process it with mysql. For example, you might have made a copy of the Country table in the world database with this command: shell> mysqldump world Country > dump.sql To reload the file later, use mysql: shell> mysql world < dump.sql One way to process a script file is by executing it with a SOURCE command from within mysql: mysql> SOURCE input_file;

Topics

#mysqldump#restore#database import#mysql client

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice