mysqldump from cron - socket error
Posted by:
Aaa Ccc
Date: June 22, 2009 01:38AM
I have a script, that backups my databases, using mysqldump:
mysqldump -h localhost -uUSER -pPASS database > /home/xxx/backup.sql
When logged in with SSH, and launching the script with all works just as it should, but when I put it in a crontab like:
0 2 * * * /home/xxx/backup.sh
I get a mail that says:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (22) when trying to connect
Subject
Views
Written By
Posted
mysqldump from cron - socket error
5574
June 22, 2009 01:38AM
2567
June 29, 2009 01:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.