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: 580

Filed under:
|

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

Related posts about centos

Related posts about cron