mysqldump

[dtm]

I'm sure this has been covered before, but since the search function in these forums is disabled I can't avoid asking...

How do I use mysqldump from the shell [or from a php script]?

When I try connecting as usual on other systems:
mysqldump -u username -p --opt dbname > dbname.`date +%Y%m%d`.sql

I get the following error:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

Do I need to specify a different socket file?

Regards, :DTM. aka Daniele Gubert

[JPC-Masood]

Please try this:

mysqldump -h 127.0.0.1 -u username -p --opt dbname > dbname.`date +%Y%m%d`.sql