1Z0-873 · Question #60
Using mysqldump, which of the following commands are used to backup one database?
The correct answer is B. shell> mysqldump world > world.sql. By default, mysqldump interprets its first non-option argument as a database name and dumps all the tables in that database. If any other arguments follow the database name, mysqldump interprets them as table names and dumps just those tables. The following command dumps the…
Question
Using mysqldump, which of the following commands are used to backup one database?
Options
- Ashell> mysqldump world world.sql
- Bshell> mysqldump world > world.sql
- Cshell> mysqldump world < world.sql
- Dshell> mysqldump -d world > world.sql
How the community answered
(46 responses)- A4% (2)
- B83% (38)
- C11% (5)
- D2% (1)
Explanation
By default, mysqldump interprets its first non-option argument as a database name and dumps all the tables in that database. If any other arguments follow the database name, mysqldump interprets them as table names and dumps just those tables. The following command dumps the contents of all the tables in the world database into a file named world.sql: shell> mysqldump world > world.sql
Topics
Community Discussion
No community discussion yet for this question.