Using xtrabackup backup to recover MyISAM data

Hello @Yali_Pear, you will always have an ibdata1 file. Even if you do not have any InnoDB tables, the innodb engine still starts by default, thus this file must exist and will always exist.

MyISAM tables are independent of eachother. You can take a backup of a MyISAM table by running ‘FLUSH TABLES WITH READ LOCK’ in one session and copy the .MYI and .MYD files to another location on disk. Backup complete. To restore, DROP TABLE first, then copy the 2 files into your datadir. Restore complete .

–databases is fully supported. Check for misspelling.

1 Like