Using xtrabackup backup to recover MyISAM data

  1. Hi,

    Why do I have ibdata1 file when backing up MyISAM data ? i don’t have InnoDB table.

  2. I can't find anything about recovering MyISAM data on the official website, How to restore a single backup of MyISAM database ?
  3. When using partial backup, when the parameter ‘--databases’ is invalid, it will also prompt for completion, Is this bug ?

thanks.

1 Like

Hello
Could you update with more information please? We could do with knowing these things:

  • what version of Percona Xtrabackup are you using?
  • What database and version are you backing up? Is it MySQL, Percona Server for MySQL or MariaDB?
  • Do you have no InnoDB in the dataset you are backing up, or do you have no InnoDB anywhere in the database? (Version plays a part here too).
1 Like

Hello,
I am using Percona Xtrabackup 2.4.19,the database version is MySQL 5.7.29.
I have other database in this mysql instance is innodb.
Excuse me, xtrabackup backup MyISAM data, can you lock only tables that need to be backed up without using global locks ?

1 Like

documentation:
https://www.percona.com/doc/percona-xtrabackup/2.4/index.html

1 Like

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