How often do you take backups?

How often do you take backups of your site?

 

Around 4 times a day on our busiest ones..

 

Once a day right now, as the site grows and I'm forced of shared hosting to a dedicated box the frequency will increase.

 

database once a day too, filesystem only after bigger changes.

 

I do mine once a week as we are still in the early stages (after recovering from a hacking) but once we get back to where we were we will go into once a day.

 

I have a backup made by shell script in the wee hours of the morning. Transferring that backup to my hard drive, however...

 

On my main forum - database backup is done nightly - every night. A couple of times a month the database is downloaded to my home computer.

On the other sites, database is backed up a couple of times a month or when changes are made to the site. Such as when updates are installed.

Complete backup of the sites /html root to my home computer the is done every couple of months.

Back ups are then backed up to either DVD or on my Seagate passport drive.

At any given time I should have at least 2 or 3 copies of the database - on the server in the backup folder, on my home computer, and backed up on removable or portable disk.

when I go on vacation I'll load a couple of the latest copies of the database on my passport drive. That way if my house burns down, I have copies. Copies of my kids pictures and family videos are also stored on the passport drive.

 

Database for the live site - every day
Database for the test site - once a week
Attachment and other image directories are zipped once a week

All files are rsynced to an offsite server every day - all files (site files and image files) and any backups that were made.

 

I backup the forum about 5 times a week. I backup the site files if I do any changes to them.

 

All my servers take a FULL backup 4 times daily. Very very useful.

 

The database is automatically backed-up once per day. I manually backup the files every once in a blue moon (I know, it's a bad non-habit. I can't find any automatic solution to make it easier).

 

We backup our DB's nightly automatically, all files once per day automatically and download a full backup with dbs etc once a week and store them on a rewritable CDR

 

I have my servers take automatic backups on a nightly basis (stored on both secondary drives and remotely). I then take backups for each individual account, just to be safe.

 

I've never run a semi-busy forum, so most of mine are once a week for database, partial file backups before and after installing minor modifications, and full file backups for major mods or upgrades.

I also do a full account backup of the one VPS I manage every single month, downloading it locally to my HDD. I need some blank DVDs, so I can do a few backup discs every month or two.

 

I use a script that I posted over on vb.org to backup and zip all the attachments/avatars/etc - Cron job for Files Backup (attachments, avatars, etc.) I think cPanel (if that is what you use) also have a way to back up files.

 

Is cPanel the best way you guys run your auto backups?

 

Make a WinSCP script : )

 

I believe control panels are tools of the devil. I just use crontab directly.

 

Interesting. Does the scripting work with ftp as well as ssh? I don't have ssh access...

 

Right now I am backing my database around once a week.