Showing results for 
Show  only  | Search instead for 
Did you mean: 
AppDynamics Team (Retired)


While taking a metadata backup of the Controller using the 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 



For mysqldump (used in the script):


  • If host is set to localhost, then a socket or pipe is used.
  • If host is set to, 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.



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


Change from:


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



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


Version history
Last update:
‎09-14-2018 10:53 AM
Updated by:
June 26 Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.

Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!

Read the blog here