Error when running mysqldump

**Jeff75** · 12-31-2004 12:59 AM

Can someone tell me why the following error comes up when trying to run mysqldump in shell?

-su-2.05b$ php ./db_backup.php
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) when trying to connect

**casey** · 12-31-2004 01:08 AM

Does /tmp/mysql.sock exist?

**Jeff75** · 12-31-2004 01:31 AM

Yes, it does exist.

**casey** · 12-31-2004 01:35 AM

What are the permissions on it?

**Jeff75** · 12-31-2004 01:41 AM

srwxrwxrwx 1 mysql wheel 0B Dec 31 01:58 mysql.sock

**casey** · 12-31-2004 02:35 AM

What user are you running the script as?

**Jeff75** · 12-31-2004 09:36 AM

I'm running it as a cPanel user account which has "normal" shell access enabled in WHM.

**AndyReed** · 12-31-2004 10:33 AM

Are you sure that mysql.sock exits in the /var/lib/mysql/ and in /tmp/
I have seen many problems like that and solving this issue varies from one server to another.

LinkBack

Thread Tools

Error when running mysqldump

Mysqldump error in VPS

Error running cpbackup: ls: reading directory .: Input/output error

mysqldump+error:1033+Table xyz was created with a different version of MySQL.

MySQLDump Broken

mysqldump problem