1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ184

Backup and Recovery

Examine the following command:

shell> mysqldump --single-transaction --flush-logs —master-data=2 --all-databases > backup_sunday.sql

What additional action does the server perform when the --flush-logs option is used?

  • A It deletes old error logs.
  • B It starts a new binary log.
  • C It starts a new undo log.
  • D It deletes old binary logs.
Explanation

Flushing MySQL logs closes the current binary log and opens a new binary log file with the next sequence number when binary logging is enabled. Log flushing does not delete existing logs or create an undo log.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!