# innobackupex is not backing up my innodb database and table **URL:** \ **Category:** Percona Server for MySQL 5.6\ **Created:** [December 5, 2016, 3:20pm UTC](https://forums.percona.com/t/innobackupex-is-not-backing-up-my-innodb-database-and-table/5258 "2016-12-05T15:20:39Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![stephensonk](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@stephensonk](https://forums.percona.com/u/stephensonk)\ **Post date:** [December 5, 2016, 3:20pm UTC](https://forums.percona.com/t/innobackupex-is-not-backing-up-my-innodb-database-and-table/5258/1 "2016-12-05T15:20:39Z")
I setup xtrabackup and a mysql database to backup. When I run the below command, my database kyle and table che that is innodb does not get backed up. Any ideas on why? innobackupex --host=10.124.164.14 --user=bkpuser --password=s3cret /data/bkps/ root@d-gp2-couch77-1:/data/bkps/2016-12-05\_20-19-29# ls -ltrh total 13M -rw-r----- 1 root root 12M Dec 5 20:19 ibdata1 drwxr-x— 2 root root 4.0K Dec 5 20:19 performance\_schema drwxr-x— 2 root root 4.0K Dec 5 20:19 mysql -rw-r----- 1 root root 2.5K Dec 5 20:19 xtrabackup\_logfile -rw-r----- 1 root root 113 Dec 5 20:19 xtrabackup\_checkpoints -rw-r----- 1 root root 418 Dec 5 20:19 backup-my.cnf -rw-r----- 1 root root 461 Dec 5 20:19 xtrabackup\_info root@d-gp2-couch77-1:/data/bkps# innobackupex --host=10.124.164.14 --user=bkpuser --password=s3cret /data/bkps/ 161205 20:19:29 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints “completed OK!”. Unrecognized character \x01; marked by ← HERE after ← HERE near column 1 at - line 1374. 161205 20:19:29 Connecting to MySQL server host: 10.124.164.14, user: bkpuser, password: set, port: 3306, socket: /var/run/mysqld/mysqld.sock Using server version 5.6.33-0ubuntu0.14.04.1 innobackupex version 2.4.5 based on MySQL server 5.7.13 Linux (x86\_64) (revision id: e41c0be) xtrabackup: uses posix\_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb\_data\_home\_dir = . xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 2 xtrabackup: innodb\_log\_file\_size = 50331648 InnoDB: Number of pools: 1 161205 20:19:29 \>\> log scanned up to (1626017) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 2 for mysql/innodb\_index\_stats, old maximum was 0 161205 20:19:30 [01] Copying ./ibdata1 to /data/bkps//2016-12-05\_20-19-29/ibdata1 161205 20:19:30 [01] …done 161205 20:19:30 [01] Copying ./mysql/innodb\_index\_stats.ibd to /data/bkps//2016-12-05\_20-19-29/mysql/innodb\_index\_stats.ibd 161205 20:19:30 [01] …done 161205 20:19:30 [01] Copying ./mysql/slave\_relay\_log\_info.ibd to /data/bkps//2016-12-05\_20-19-29/mysql/slave\_relay\_log\_info.ibd 161205 20:19:30 [01] …done 161205 20:19:30 [01] Copying ./mysql/slave\_worker\_info.ibd to /data/bkps//2016-12-05\_20-19-29/mysql/slave\_worker\_info.ibd 161205 20:19:30 [01] …done 161205 20:19:30 [01] Copying ./mysql/innodb\_table\_stats.ibd to /data/bkps//2016-12-05\_20-19-29/mysql/innodb\_table\_stats.ibd 161205 20:19:30 [01] …done 161205 20:19:30 [01] Copying ./mysql/slave\_master\_info.ibd to /data/bkps//2016-12-05\_20-19-29/mysql/slave\_master\_info.ibd 161205 20:19:30 [01] …done 161205 20:19:30 \>\> log scanned up to (1626017) 161205 20:19:31 Executing FLUSH NO\_WRITE\_TO\_BINLOG TABLES… 161205 20:19:31 Executing FLUSH TABLES WITH READ LOCK… 161205 20:19:31 Starting to backup non-InnoDB tables and files 161205 20:19:31 [01] Copying ./performance\_schema/table\_io\_waits\_summary\_by\_index\_usage.frm to /data/bkps//2016-12-05\_20-19-29/performance\_schema/table\_io\_waits\_summary\_by\_index\_usage.frm 161205 20:19:31 [01] …done 161205 20:19:31 [01] Copying ./performance\_schema/host\_cache.frm to /data/bkps//2016-12-05\_20-19-29/performance\_schema/host\_cache.frm 161205 20:19:31 [01] …done … 161205 20:19:31 [01] Copying ./mysql/help\_category.MYD to /data/bkps//2016-12-05\_20-19-29/mysql/help\_category.MYD 161205 20:19:31 [01] …done 161205 20:19:31 Finished backing up non-InnoDB tables and files 161205 20:19:31 Executing FLUSH NO\_WRITE\_TO\_BINLOG ENGINE LOGS… xtrabackup: The latest check point (for incremental): ‘1626017’ xtrabackup: Stopping log copying thread. .161205 20:19:31 \>\> log scanned up to (1626017) 161205 20:19:31 Executing UNLOCK TABLES 161205 20:19:31 All tables unlocked 161205 20:19:31 Backup created in directory ‘/data/bkps//2016-12-05\_20-19-29’ 161205 20:19:31 [00] Writing backup-my.cnf 161205 20:19:31 [00] …done 161205 20:19:31 [00] Writing xtrabackup\_info 161205 20:19:31 [00] …done xtrabackup: Transaction log of lsn (1626017) to (1626017) was copied. 161205 20:19:31 completed OK!