2002 Error with MySQLDump

[DiecastAviation]

Our ISP has given us SSH access, and I know using mysqldump is the recommended backup option, however when I come to run the command - I get a 2002 error and "Can't connect to local MySQL server through socket /var/lib/mysql.sock"

I am assuming we do not have the rights to do this, as our ISP seems to be pushing us down the phpmyadmin route for backup - following a conversation I had with them today.

Is there a thread anywhere regarding using this for backup - I recall seeing something but now cannot find it.....

Thanks....

[Floris]

http://www.vBulletin.com/docs/html has an appendix with techn. documentation.

[Steve Machol]

This error means either MySQL crashed, it's not running or it can't find the socket. You need to contact your host about this. Here is more info on this error:

http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html

[DiecastAviation]

Actually spot on again Steve - the clue was in the error message - and remembering a conversation I had with the ISP earlier this week - the Mysql is not on the Server we are on.

So I just added the -h command with the FQDN of the MySQl and it worked.


Excellent....