# innobackupex not working properly in a MySQL Multi Instance Setup

**URL:** <https://forums.percona.com/t/innobackupex-not-working-properly-in-a-mysql-multi-instance-setup/2162>\
**Category:** Percona XtraBackup\
**Created:** [August 5, 2011, 5:28am UTC](https://forums.percona.com/t/innobackupex-not-working-properly-in-a-mysql-multi-instance-setup/2162 "2011-08-05T05:28:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chasecohen](https://avatars.discourse-cdn.com/v4/letter/c/e9a140/32.png) [@chasecohen](https://forums.percona.com/u/chasecohen)\
**Post date:** [August 5, 2011, 5:28am UTC](https://forums.percona.com/t/innobackupex-not-working-properly-in-a-mysql-multi-instance-setup/2162/1 "2011-08-05T05:28:39Z")

</div>

I’m in the process of testing innobackupex in a multi instance setup. So two ports, one 3306 and the other 3308.

When I supply the innobackupex command, it says it’s connecting to the right place (3308), but the seeems to be backing up data from the default port (3306). As I supply a list of databases to backup, the resulting backup is pretty much useless.

The command I run  
perl /usr/local/bin/mysql-backups/innobackupex-1.5.1 --port=3308 --slave-info --databases=“” --user= --password= --stream=tar . | gzip - \> dbbackup-3308.tar.gz

The output  
110805 11:53:11 innobackupex-1.5.1: Starting mysql with options: --password=\*\*\*\*\* --user=\*\*\*\*\* --port=3308 --unbuffered –

xtrabackup: innodb\_data\_home\_dir = /var/lib/mysql  
xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = /var/lib/mysql

The innodb parameters it says there are for the default port of 3306 and not 3308, so it’s pulling the wrong part out of the my.cnf. Plus if I check the processlist for 3306 when the backup starts, I can see the backup process in there.

Is there something I am doing wrong? Has anyone got this to work before? I even tried specifying the 3308 socket file, but no joy there either.

Help?

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [August 10, 2011, 10:27pm UTC](https://forums.percona.com/t/innobackupex-not-working-properly-in-a-mysql-multi-instance-setup/2162/2 "2011-08-10T22:27:06Z")

</div>

Are you using the grouped mysqld instances on your my.cnf? The xtrabackup binary does not support this feature yet (I was trying to hack it with my primitive C but could only progress like a baby).

What you can do is create separate \*.cnf file for each instance with a minimum content like below for port 3308:

my3308.cnf

[mysqld]  
datadir=/path/to/mysql/dir