Not the answer you need?
Register and ask your own question!

why the number of .frm files backuped is not enough

johnwangjohnwang EntrantInactive User Role Beginner
I'm a newer to the xtrabackup. The version of the xtrabackup installed is v1.5.1.
There are 100 .frm files in mysql data directory. However, there are only 8 .frm files in the backup data directory. I use the full backup command, such as
/usr/bin/innobackupex --user=$User --password=$Passwd --defaults-file=/etc/my.cnf --database=$Database $databak_dir

I view the backup log. No error hints occur.
121224 03:01:44 innobackupex: completed OK!
BackupFileName:xishiqu
DataBase Backup Success

I wonder whether the backup is OK for xtrabackup?

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    I see in that command line that you are only backing up one single database. You should compare the number of tables on that database with the number of .frm files on the backup directory.

    The log of the backup process will also help, attach it please.
  • johnwangjohnwang Entrant Inactive User Role Beginner
    I have sovled the problem. the problem is not due to innobackupex. Thanks!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.