There are different backup types, for example:
- textual (logical) / binary (physical)
- online / offline
- full / incremental
The result of a textual backup are text files. They can be easily moved to other db-servers or to different applications.
But restoring those files can be CPU intensive, as indexes need to be recreated.
A binary backup makes copies of mysql’s own files. This kind of backup is very efficient, but internal knowledge and/or special tools are needed.
Pick two means of making textual backups with mysql.
a) mysqlhotcopy b) mysqldump c) ibbackup d) select into outfile
[ Data Backup and Recovery Methods (15%) - Binary Versus Textual Backups ]
b d
Mysqlhotcopy works with Myisam tables and is very fast, but during the backup the tables cannot be written to.
Ibbackup makes fast non-locking backups of InnoDB tables.