Topic: Cron Job Backups + MySQLDumper

[Ken (OP)]

Trying to set up a daily backup using a Cron Job... here's my current command:

Code: [Select]

/home/ourfamil/daily.sh

[Ken (OP)]

That didn't work! 

Gave me this error:

Code: [Select]

/usr/local/cpanel/bin/jailshell: /home/ourfamil/daily.sh: No such file or directory

[Skhilled]

I cannot see that file...then again my FTP account only starts at /public_html. That file should be before it in the /home/ourfamil folder...

[Ken (OP)]

I'll see if your access can be changed.

[Ken (OP)]

Looks like I'll have to delete the account and make a new one for you. 

[Skhilled]

Do you know where the backup is placed and what the name of the file will be? If so, you can check there to see if it worked.

[Ken (OP)]

It is supposed to email a copy of the db backup to me, but I don't yet know where the file gets stored when it is created.

[Skhilled]

If all you are looking for is to backup the db then try this:

http://www.docskillz.com/docs/index.php?topic=333.0

[Ken (OP)]

Got it installed, now me just need to learn how to set it up. 

[Skhilled]

Extract it and got to the /ReadMe folder and read install_english.txt.

[Ken (OP)]

If all you are looking for is to backup the db then try this:

http://www.docskillz.com/docs/index.php?topic=333.0

The MySQL Dumper utility worked. 

It now is doing a backup once a day and sending it to me in an email. 

[Skhilled]

Excellent!

[Ken (OP)]

If all you are looking for is to backup the db then try this:

http://www.docskillz.com/docs/index.php?topic=333.0

The MySQL Dumper utility worked. 

It now is doing a backup once a day and sending it to me in an email. 

Actually, I should have said that my cPanel Cron Job utility is being used to initiate  and download the backup from the MySQL Dumper... I'm still trying to learn how to do the download from within MySQL Dumper so as to eliminate the extra step of using the cPanel.