GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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
Working...
X