Jump to content


Photo

Cron Job Backup


  • Please log in to reply
5 replies to this topic

#1 rowanhippy

rowanhippy

    Newbie

  • Members
  • Pip
  • 4 posts
  • Gender:Male
  • Location:near the hills

Posted 08 April 2011 - 04:27 AM

Hi

On our site i use Mysqldumper to automate the backup, it outputs a command to enter as a cron job in cPanel. I have it all set up but just wanted to make sure that the time that the backup is carried out is okay with yourselves or should i adjust the time. I have never been much good at timezones.

Thanks. :D

0 2 * * * perl /home/friendsc/public_html/mysqlbackup/msd_cron/crondump.pl -config=mysqldumper -html_output
  • 0
rowanhippy

"To touch the earth is to have harmony with nature." Oglala Sioux

#2 fshagan

fshagan

    Member

  • Members
  • PipPip
  • 145 posts

Posted 08 April 2011 - 03:22 PM

I'm sure Mike will chime in, but a lot of people tend to do things at the top of the hour. I try to schedule my cron jobs so that they run at 12 minutes after, or 48 minutes after, etc., just to try to miss that peak period.
  • 1

#3 rowanhippy

rowanhippy

    Newbie

  • Members
  • Pip
  • 4 posts
  • Gender:Male
  • Location:near the hills

Posted 09 April 2011 - 04:00 AM

I'm sure Mike will chime in, but a lot of people tend to do things at the top of the hour. I try to schedule my cron jobs so that they run at 12 minutes after, or 48 minutes after, etc., just to try to miss that peak period.


Thanks for your reply fshagan, it makes sense doing it that way. I have adjusted mine to 17 minutes after the hour now.
  • 0
rowanhippy

"To touch the earth is to have harmony with nature." Oglala Sioux

#4 MikeDVB

MikeDVB

    Forum Administrator

  • Staff Administrator
  • PipPipPipPipPip
  • 2,900 posts
  • Gender:Male
  • Location:Central Indiana, USA

Posted 09 April 2011 - 07:46 AM

Also do make sure that the backup file generated is complete, check the email that is sent to you about the backup because we've recently put a system in place that prevents cPanel backups from capturing the home directory WHILE the R1Soft backup system is backing up the server. This is approximately 1 hour per night and varies from server to server (but is the same time every night on each server).

It will say in the email from the backup system if this was the case.
  • 0
Michael Denney - MDDHosting LLC - Providing Hosting since 2007
Scalable shared hosting plans in the cloud! Check them out!
Highly Available Cloud Shared, Reseller, and VPS
http://www.mddhosting.com/

#5 rowanhippy

rowanhippy

    Newbie

  • Members
  • Pip
  • 4 posts
  • Gender:Male
  • Location:near the hills

Posted 10 April 2011 - 04:07 AM

Also do make sure that the backup file generated is complete, check the email that is sent to you about the backup because we've recently put a system in place that prevents cPanel backups from capturing the home directory WHILE the R1Soft backup system is backing up the server. This is approximately 1 hour per night and varies from server to server (but is the same time every night on each server).

It will say in the email from the backup system if this was the case.


Thanks Mike.

I have checked this morning and the backup is of the right size and the email sent reported it had completed fully.

Thanks both for the input, its much appreciated.
  • 0
rowanhippy

"To touch the earth is to have harmony with nature." Oglala Sioux

#6 stocktrader

stocktrader

    Member

  • Members
  • PipPip
  • 50 posts

Posted 12 April 2011 - 03:44 PM

When someone does a nightly cPanel backup, does it transfer the whole file directory each time? I do only an incremental backup where it only (transfers files that have changed) because I assumed it would be easier and quicker. Then I do a separate MySQL backup.

Is there any advantage to doing a cPanel backup compared to doing an FTP incremental backup with additional MySQL backup.
  • 0
ThinkTrade - My Trading Site




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users