Backup cron jobs

[FancyPants]

I need help setting up a cron job to backup the db at 00:00 and 12:00 everyday and e-mails it to me. Just like how you back it up through the Maintenance tab in the AdminCP

 

[Gempis]

There is one mod that backs up once every 24 hours...

You can take a look at it and modify it at your desires...

 

[getandshare]

I can write a sh script if you want,
to automatically backup the database,
Compress it
than remote upload it to any ftp of your choice.. @ $5.

Ofcourse, you shall have ssh access to the server for that...

 

[SS-Chris]

Try something along these lines:

http://www.theblog.ca/mysql-email-backup

This can be done without ssh access, all you need to do is set your cron job up to call it at whatever time you want.

 

[desiboy]

crontab -e

will open the crontab file.


syntax of it

* * * * * this is my command
- - - - -
| | | | |
| | | | ----- Day of week (0 - 7) (Sunday=0 or 7)
| | | ------- Month (1 - 12)
| | --------- Day of month (1 - 31)
| ----------- Hour (0 - 23)
------------- Minute (0 - 59)

and alternatively you can use

@daily /path/to/backup/foo.sh

which will call the scrript foo.sh daily ( donn't forget to give the script executable permissions )

 

[FancyPants]

I will try it out ss-chris, thanks

 

[Gempis]

Here is the mod i was talking about...

http://www.lithiumstudios.org/forum/viewtopic.php?f=31&t=794

 

[FancyPants]

Gempis: It doesn't e-mail it to me

 

[Gempis]

Oh, didn't see you wanted that... :S

Sorry