Announcement

Announcement Module
Collapse
No announcement yet.

i have problem in database hosted in multiple port backups

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

    raj

  • #2
    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.

    Comment

    Working...
    X