Database backup

gladiator · #1 (**permalink**) 05-24-2007, 12:39 AM

Your web host definitely backs up your database regularly but it is a must that you have to undertake your own back up task regularly. How do you automate your database back up?

Xenigo123 · #2 (**permalink**) 05-24-2007, 01:01 AM

Don't be so sure that your web host is backing up your database regularly. I've read tons of horror stories about web hosts going down and mysteriously losing entire databases that were supposedly being backed up. My hard work is way to important to me to trust any web host or automated service, so I back up my database daily on my own as I update daily on my sites.

yogesh · #3 (**permalink**) 05-24-2007, 08:43 AM

I backup my database on a daily basis, in fact I use a cron job that runs on regular intervals to make a dump of the MySQL db in a folder.

alpha · #4 (**permalink**) 05-24-2007, 09:07 AM

cron jobs are the way to go. If you using wordpress etc to host your site, there are plugins like wp_backup which will do it on a scheduled basis. It can even mail it to you. I do a regular backup to my gmail account every DAY.

The Walsho · #5 (**permalink**) 05-25-2007, 05:08 PM

I tend to do mine every weekend, but I admit I do forget sometimes. I should really get into the habit of doing it more often though.

gladiator · #6 (**permalink**) 05-25-2007, 05:27 PM

Quote:

Originally Posted by gladiator

Your web host definitely backs up your database regularly but it is a must that you have to undertake your own back up task regularly. How do you automate your database back up?

If your web host is Linux based, you check with your webhost if you can do it using CRON. That saves you a lot of your time doing the task manually.

G11-Tech · #7 (**permalink**) 05-25-2007, 05:36 PM

Backups aren't that important for me so I'll usually only do them every month or so. Manually it doesn't take too long - around 5 mins to download everything and store it.

wesley · #8 (**permalink**) 05-25-2007, 09:18 PM

I think that backups are crucial for sites that run on some kind fo database. For html sites, I don;t worry so much as I have the files on a local hard drive.

But when DBs are being constantly updated, the backups need to be done often. I have made the mistake of losing good content by not being proactive.

subodh · #9 (**permalink**) 05-26-2007, 02:18 PM

I have undergone two disaster for not taking database backup. Previously I am using freehost, it closes without warning. Also some months ago my another site get hacked. Hacker clean all news, articles.
So, I am now taking backup after three days regularly, to avoid such problem.

decent-lord · #10 (**permalink**) 06-07-2007, 10:18 PM

will yeah you shouldn't to trust these web hosting companies they dont take the backup all the times . I take my site backup after each 3 or 2 days for the security reason .

ashish1987 · #11 (**permalink**) 06-08-2007, 06:55 AM

I take backups of my MySQL database quite frequently.
I started doing this after i had to change a server and i didn't have a database backup.

exculiber · #12 (**permalink**) 06-08-2007, 12:23 PM

What I have been doing is I populate first my local site then port my database to my live site. Whatever happens to my live site, I am confident I have a ready back copy with me. By the way this is applicable to sites which do not require inputs from online users.