automysqlbackup not working weirdly on shared host
Posted
by
KPL
on Server Fault
See other posts from Server Fault
or by KPL
Published on 2012-03-20T03:45:09Z
Indexed on
2012/03/20
5:31 UTC
Read the original article
Hit count: 620
I'm on HostGator and I have not-root-level SSH access.
I manually setup automysqlbackup in a /home/user/automysqlbackup
folder. Created a file called runbackup
in the same folder, chmod +x'ed it. The content :
/home/user/automysqlbackup/automysqlbackup /home/user/automysqlbackup/myserver.conf
Now, when I run ./runbackup
from shell, no email is sent.
I've setup a daily cron job. The crontab line reads -
24 06 * * * /home/user/automysqlbackup/runbackup
When the crontab is run, I do get an email, but, the subject is
WARNING: Error Reported - MySQL Backup Log and SQL Files for localhost - 012-03-19_06h24m
The email does have an attachment, but it just has the SQL for creating tables. No data in the several rows at all.
I don't know what wrong I'm doing and this is freaking me out!
I tried writing a custom script as well, using this guide, but mutt
doesn't send email, then.
The OS used by HostGator is CentOS.
© Server Fault or respective owner