your ideas ... (How often do you backup your database?)

ohrana's picture

They have: 156 posts

Joined: Sep 2006

I wonder how often you prefer to back up your database?

They have: 95 posts

Joined: Nov 2006

Why not rely on your host in these questions?

timjpriebe's picture

He has: 2,667 posts

Joined: Dec 2004

You should never rely completely on your host, mostly because they can fail. Some hosts back up the files but say you're responsible for backing up the database.

In addition to my host's backup, I do a daily backup as well. The biggest advantage is that if anything happens, I don't have to wait on my host to take care of it. I can do it myself, which tends to be much faster.

James's picture

He has: 127 posts

Joined: Dec 2005

Daily backup of your databases is essential Smiling

He has: 1,758 posts

Joined: Jul 2002

I keep local backups on my main computer which I backup to an external drive. If I do database driven websites for clients I always give them a way to back up the database and instruct them to do it regularly. If they don't make backups and something goes wrong they and they alone are responsible.

Andy

They have: 112 posts

Joined: Sep 2006

Why are daily backups necessary, if the site isn't changed every day?

She has: 13 posts

Joined: Dec 2006

We have learned from bitter experience that you should back up everything at least every couple of days, if not more often. Trouble is when things are going well it's easy not to bother. Don't fall into that trap, you could live to regret it, we have.

mik-crap's picture

He has: 30 posts

Joined: Jan 2007

Organisations usually require daily back-ups because the data is modified on a daily basis. They usually follow the family protocol for back-ups (Grand-father/father/son).

For personal sites, I would recommend a bi-weekly back-up. This of course assumes you make less than 7 updates (as in content). If you have, say a post a day, then back-up bi-daily.

Also, for personal sites, a good tool to use is your text editor. Write your content in there, save it on your local machine, then add it to your site. Instant back-up and online version.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.