percona-discussion team mailing list archive

[Evgeniy Stepchenko <evgeny.stepchenko@xxxxxxxxxxx>]

not a bug

** Changed in: percona-xtrabackup
       Status: New => Invalid

-- 
xtrabackup only processes the first db it founds
https://bugs.launchpad.net/bugs/346048
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraBackup.

Status in Open source backup tool for InnoDB and XtraDB: Invalid

Bug description:
When running xtrabackup against my databases I found out that it only processes the first one:

inkdev:/var/lib/mysql# ls -lah
total 45M
drwxr-xr-x  9 mysql mysql 4.0K Mar 20 18:40 .
drwxr-xr-x 28 root  root  4.0K Mar 19 02:47 ..
drwx------  2 mysql mysql 4.0K Mar 19 02:56 cacti
-rw-r--r--  1 mysql mysql    0 Mar 19 02:47 debian-5.0.flag
-rw-rw----  1 mysql mysql 5.0M Mar 20 18:53 ib_logfile0
-rw-rw----  1 mysql mysql 5.0M Mar 20 18:53 ib_logfile1
-rw-rw----  1 mysql mysql  34M Mar 20 18:53 ibdata1
drwx------  2 mysql mysql 4.0K Mar 19 03:26 inkzee
drwx------  2 mysql mysql 4.0K Mar 19 03:27 inkzeeLog
drwxr-xr-x  2 mysql root  4.0K Mar 19 03:27 mysql
-rw-------  1 mysql mysql    6 Mar  3 19:24 mysql_upgrade_info
drwx------  2 mysql mysql 4.0K Mar 19 03:27 neurosecurity
drwx------  2 mysql mysql 4.0K Mar 19 03:27 wordpress

When running xtrabackup:
inkdev:/home/www/percona/mysql-5.0.77/innobase/xtrabackup-0.3.src# ./xtrabackup --backup
./xtrabackup  Ver alpha-0.3 for 5.0.77 pc-linux-gnu (i686)
>> log scanned up to (0 2688764947)
Copying ./ibdata1
     to /var/lib/mysql/backup2/ibdata1
        ...done
Copying ./inkzee/Comment.ibd
     to /var/lib/mysql/backup2/inkzee/Comment.ibd
        ...done
...
[ cut some lines for simplicity's sake ]

Copying ./inkzee/linksTo.ibd
     to /var/lib/mysql/backup2/inkzee/linksTo.ibd
>> log scanned up to (0 2688884420)
        ...done
>> log scanned up to (0 2688891755)
Stopping log copying thread........
Transaction log of lsn (0 2688755844) to (0 2688891755) was copied.
inkdev:/home/www/percona/mysql-5.0.77/innobase/xtrabackup-0.3.src#

As you see, it only processed the first database directory.
inkdev:/home/www/percona/mysql-5.0.77/innobase/xtrabackup-0.3.src# cat /etc/my.cnf | grep datadir
datadir         = /var/lib/mysql

Afaik it should process all of them or at least ask which one you want to backup.

Hope this helps :)