Not the answer you need?
Register and ask your own question!

i have problem in database hosted in multiple port backups

karpagarajkarpagaraj EntrantCurrent User Role Beginner
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

raj

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.