views:

80

answers:

4

Hi everyone, I need to back up a big database everydays. Should I code it myself in PHP or is there a good script out there ?

+4  A: 

If you run your server under linux use a cronjob to do it (for example nightly)! Cron could trigger mysqldump (in case you are using MYSQL) backing up your database(s).

Thariama
Also worth considering if it's MySQL on Linux is http://sourceforge.net/projects/automysqlbackup/ -- this again can be triggered by cron, and uses mysqldump, but it stores daily, weekly and monthly backup cycles in a nice structure and is quite configurable.
Matt Gibson
+1  A: 

You can cronjob the tool provided with your DBMS

M42
+2  A: 

Yes, here is an award-winning script at phpclasses.org.

Sarfraz
A: 

If you're using cPanel or Plesk or something then they generally have back-up scripts available to you (but as Chris Aitchison says), how useful any of these answers are depends on the details.

hollsk