What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?
A.
Mysql Enterprise Backup
B.
Mysqldump with – binary-data option
C.
Mysqlhotcopy
D.
File system snapshots
E.
Mysqldumpslow
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html
The answer are A, D
A, D.
A and D.
Scripts mysqldump or others do not support binary.
Answers A and D
http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html
is A, B
In addition to making binary backups as just described, regularly make dumps of your tables with mysqldump.
Without “binary-data” parameter
A, D
Answer Should be :A and D
AD