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

innobackupex is not backing up my innodb database and table

stephensonkstephensonk EntrantInactive User Role Beginner
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/

[email protected]:/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



[email protected]:/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!
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.