Which two are correct steps in taking a binary backup of MyISAM tables?

Which two are correct steps in taking a binary backup of MyISAM tables?

Which two are correct steps in taking a binary backup of MyISAM tables?

A.
Always stop the server prior to the backup.

B.
Stop the server or lock the tables prior to the backup.

C.
Stop the server or lock the databases prior to the backup.

D.
Make a copy of the .frm, .myd, and the .myi files.

E.
Make a copy of the binary log and tablespace files.

Explanation:
–Reference: http://dev.mysql.com/doc/refman/5.6/en/backup-methods.html

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Me

Me

B,D RM 5.6 859

Reply

Jose Wilson

Jose Wilson

Making Backups by Copying Table Files

For storage engines that represent each table using its own files, tables can be backed up by copying those files. For example, MyISAM tables are stored as files, so it is easy to do a backup by copying files (*.frm, *.MYD, and *.MYI files). To get a consistent backup, stop the server or lock and flush the relevant tables.

http://dev.mysql.com/doc/refman/5.6/en/backup-methods.html

Altermatives b and d is correct.

Reply