Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
The mysqldump command with the `--all-databases` option backs up all databases to the output file. Additionally, the `--delete-master-logs` option deletes the non-active binary logs from the master after the dump is completed, while keeping the active log intact.
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_delete-master-logs
A. yes, all databases are backedup. Not D, it doesn't backup binary logs. B or C, probably B, because there might logs made after the dump is started. So you are not deleting all logs.
incorrect not D, it doesn't backup them up
B, non active logs i think, there is always one active log, after mysqldump it rotates the log and will purge the old ones
sorry me again, A. All databases are backed up to the output file. No, sys, information_schema, performance_schema are not backed up. But I think they mean yes to this. B. All non-active binary logs are removed from the master. Yes, the last binlog is active and does not get deleted. C. All binary logs are deleted from the master. No, last one is not. Tested this. D. All binary logs are backed up and then deleted. No, they are not backed up. E. All databases, excluding master metadata, are backed up to the output file. Maybe, if sys, performance_schema, information_schema are all meta, then yes, otherwise no. My guess is no. Performance_schema is not meta. F. All details regarding deleted logs and master metadata are captured in the output file. No.
A-All databases are backed up to the output file. This is true because the --all-databases option tells mysqldump to dump all databases. C-All binary logs are deleted from the master. This is true because the --delete-master-logs option tells mysqldump to delete all binary logs on the master server2. However, it’s important to note that deleting the MySQL binary logs with mysqldump --delete-master-logs can be dangerous if your server is a replication source server, because replicas might not yet fully have processed the contents of the binary log
AC. >8.0.26 use --delete-source-logs
AC. D. All binary logs are backed up and then deleted (FALSE): The mysqldump command doesn't have the capability to back up binary logs. It only deals with backing up database schemas and data.