i have problem in database hosted in multiple port backups

I have the machine running with multiple instances.

I need to take the backup of incremental backups for the port of 3307 only.

I using this command for take backup

innobackupex-1.5.1 --port=3307 --no-lock --socket=/backup/mysql_data/mysql.2.sock /backup/

I facing this error while take backup
innobackupex-1.5.1: Starting mysql with options: --port=‘3307’ --socket=’/backup/mysql_data/mysql.2.sock’ --unbuffered –
121218 10:15:22 innobackupex-1.5.1: Connected to database with mysql child process (pid=30526)
innobackupex-1.5.1: Error: mysql child process has died: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/backup/mysql_data/mysql.2.sock’ (2)

Anyone can pls help me to fix this

Thanks in advance


Error 2 means that the file /backup/mysql_data/mysql.2.sock doesn’t exist. Please, double check that the socket exists. You can also try to run the backup specifying only the port number and hostname and not the socket.