Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I resolve MySQL socket errors when taking Controller data backups?

Symptoms

While taking a metadata backup of the Controller using the ControllerMetadataBackup.sh script (as outlined in the

Controller Data Backup and Restore documentation) it fails with error message:

 

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect 

 

Diagnosis

For mysqldump (used in the ControllerMetadataBackup.sh script):

 

  • If host is set to localhost, then a socket or pipe is used.
  • If host is set to 127.0.0.1, then the client is forced to use TCP/IP.

No host is set in the script by default, therefore on some servers, the script might fail while trying to use socket to connect to MySQL.

 

Solution

Add -h with the Controller hostname to the mysqldump options in the ControllerMetadataBackup.sh script. This forces mysqldump to use TCP/IP.

 

Change from:

 

$appd_install_dir/db/bin/mysqldump -u root -p[password] -P [port_number] controller 

 

To:

 
$appd_install_dir/db/bin/mysqldump -u root -p[password] -h [controller_host_name] -P [port_number] controller 

 

Version history
Revision #:
5 of 5
Last update:
‎09-14-2018 10:53 AM
Updated by:
 


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.
0 Kudos