percona-discussion team mailing list archive

[Alex Barrera <abarrera@xxxxxxxxxx>]

You are completely right, the rest of dbs don't have innodb tables.
Nevertheless I'm going to double check by adding an extra db with innodb
tables and I'll report back.

Alex

-- 
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: New

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 :)