# innobackupex does not do backup of certain tables, but backups ALL

**URL:** <https://forums.percona.com/t/innobackupex-does-not-do-backup-of-certain-tables-but-backups-all/2231>\
**Category:** Percona XtraBackup\
**Created:** [April 10, 2012, 4:51pm UTC](https://forums.percona.com/t/innobackupex-does-not-do-backup-of-certain-tables-but-backups-all/2231 "2012-04-10T16:51:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zentavr](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zentavr/32/869_2.png) [@zentavr](https://forums.percona.com/u/zentavr)\
**Post date:** [April 10, 2012, 4:51pm UTC](https://forums.percona.com/t/innobackupex-does-not-do-backup-of-certain-tables-but-backups-all/2231/1 "2012-04-10T16:51:30Z")

</div>

I wonder: why innobackupex does not backup only tables which I need, but do a FULL BACKUP of everything?

root@reader:/opt/mysql\_incremental# innobackupex --host=central --user=root --password=zxcvbn --databases=“tog3 sms\_down” --no-timestamp --parallel=4 --use-memory=1G /home/mysql\_incremental\_backup/fullInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.120411 00:14:08 innobackupex: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --host=‘central’ --unbuffered --120411 00:14:08 innobackupex: Connected to database with mysql child process (pid=7393)120411 00:14:14 innobackupex: Connection to database server closedIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints “completed OK!”.innobackupex: Using mysql Ver 14.14 Distrib 5.5.20, for Linux (x86\_64) using readline 5.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.innobackupex: Created backup directory /home/mysql\_incremental\_backup/full120411 00:14:14 innobackupex: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --host=‘central’ --unbuffered --120411 00:14:14 innobackupex: Connected to database with mysql child process (pid=7419)120411 00:14:16 innobackupex: Connection to database server closed120411 00:14:16 innobackupex: Starting ibbackup with command: xtrabackup\_51 --backup --suspend-at-end --target-dir=/home/mysql\_incremental\_backup/full --use-memory=1G --parallel=4innobackupex: Waiting for ibbackup (pid=7426) to suspendinnobackupex: Suspend file '/home/mysql\_incremental\_backup/full/xtrabackup\_suspended’xtrabackup\_51 version 1.6.5 for MySQL server 5.1.59 unknown-linux-gnu (x86\_64) (revision id: undefined)xtrabackup: uses posix\_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: Target instance is assumed as followings.xtrabackup: innodb\_data\_home\_dir = /var/lib/mysqlxtrabackup: innodb\_data\_file\_path = ibdata1:100M:autoextendxtrabackup: innodb\_log\_group\_home\_dir = ./xtrabackup: innodb\_log\_files\_in\_group = 2xtrabackup: innodb\_log\_file\_size = 20971520xtrabackup: use O\_DIRECT\>\> log scanned up to (153 1858805422)xtrabackup: Starting 4 threads for parallel data files transfer[03] Copying /var/lib/mysql/ibdata1 to /home/mysql\_incremental\_backup/full/ibdata1[01] Copying ./regreader2/countdown\_log\_search\_queries\_data\_2012\_04\_01.ibd to /home/mysql\_incremental\_backup/full/regreader2/countdown\_log\_search\_queries\_data\_2012\_04\_01.ibd[02] Copying ./regreader2/countdown\_log\_web\_search\_error\_data\_2012\_05.ibd to /home/mysql\_incremental\_backup/full/regreader2/countdown\_log\_web\_search\_error\_data\_2012\_05.ibd[04] Copying ./regreader2/countdown\_log\_error\_web\_data\_2011\_11.ibd to /home/mysql\_incremental\_backup/full/regreader2/countdown\_log\_error\_web\_data\_2011\_11.ibd[02] …done[02] Copying ./regreader2/countdown\_log\_search\_homepage\_data\_2012\_02\_20.ibd to /home/mysql\_incremental\_backup/full/regreader2/countdown\_log\_search\_homepage\_data\_2012\_02\_20.ibd[02] …done[02] Copying ./regreader2/countdown\_log\_search\_queries\_data\_2012\_04\_08.ibd to /home/mysql\_incremental\_backup/full/regreader2/countdown\_log\_search\_queries\_data\_2012\_04\_08.ibd^C