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