6

cron wont backup my database

view full story
linux-howto

http://serverfault.com – I uploaded the cronjob but it wont backup my database. the error email is: mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect //etc/cronjob.sh: line 48: mutt: command not found my cronjob file is: DBNAME=xxx DBPASS=xxx DBUSER=xxx #Keep the " around your address EMAIL="[email protected]" #Change the 'wp_' to match your table_prefix in the database mysqldump --opt -u $DBUSER -p$DBPASS $DBNAME > backup.sql gzip backup.sql DATE=`date +%Y%m%d` ; mv backup.sql.gz $DBNAME-backup-$DATE.sql.gz echo 'Blog Name: (HowTos)