php, sql, and database backups

Joined
Jul 7, 2008
Messages
3,963
Location
Missouri
I need to learn how to properly back up my website. It is based in php and uses a mysql database. Any good resources or basic info on this subject? It would be greatly appriciated, I just started up a blog on my site and want to be sure that my store and blog is protected from being lost.
 
I put this script in the /etc/cron.daily directory:
http://freshmeat.net/projects/mysqlbackup/
That ensures I can always return to an older state even in the event of database file corruption.

Then I use Bacula to grab an off-site copy of the whole server for disaster recovery or catastrophic hardware failure.
http://www.bacula.org/en/
 
Yeah.. the built in mysql backup works very well. If I remember in the morning at the office I'll paste in my super simple nightly date stamped bash dump script. I would highly recommend rsync for all the php/html etc. code files. Very efficient and quick. Google it and you'll be amazed how easy it all is.
 
Back
Top