For some time, we’ve been using innobackupex an it works great (thanks for it). I saw that innobackup is deprecated and should be replaced with xtrabackup binary, but according to the documnetation, that could not backup anything besides InnoDB. I was thinking some other “wrapper” will be introduced, but I didn’t find anything.
Today I just blindly tried out xtrabackup and it seems like it backups also frm, myisam…
…
160902 06:03:38 Executing FLUSH NO_WRITE_TO_BINLOG TABLES…
160902 06:03:38 Executing FLUSH TABLES WITH READ LOCK…
…
160902 06:03:38 [01] Copying ./mysql/column_stats.MYD to /backup/mysql/column_stats.MYD
160902 06:03:38 [01] …done
160902 06:03:38 [01] Copying ./mysql/column_stats.MYI to /backup/mysql/column_stats.MYI
160902 06:03:38 [01] …done
160902 06:03:38 [01] Copying ./mysql/column_stats.frm to /backup/mysql/column_stats.frm
160902 06:03:38 [01] …done
160902 06:03:38 [01] Copying ./mysql/columns_priv.MYD to /backup/mysql/columns_priv.MYD
160902 06:03:38 [01] …done
160902 06:03:38 [01] Copying ./mysql/columns_priv.MYI to /backup/mysql/columns_priv.MYI
160902 06:03:38 [01] …done
160902 06:03:38 [01] Copying ./mysql/columns_priv.frm to /backup/mysql/columns_priv.frm
…
160902 06:03:40 Executing UNLOCK TABLES
160902 06:03:40 All tables unlocked
Should the documentation ([url]https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup_bin/limitation.html[/url]) be updated then?
Thanks