MySQL Enterprise Backup(MEB) does hot backup of innodb data and log files. Till MEB 3.6.1, the user backs up the only innodb tables in a 3 step process:
STEP 1. Take backup using --only-innodb option
STEP 2. Temporarily make the table read only by executing “FLUSH TABLES WITH READ LOCK”
STEP 3. Manually copy the .frm files of innodb tables to the destination directory where backup is stored.
MEB 3.7.0 has an enhancement to innodb file copying. The .frm files gets copied along with the hot backup done for innodb files. I …[Read more...]