Very good advice! I must admit that I often forget to backup prior to adding a Mod. I always add the mod to my test site first, and if there are no problems, then I add it to my real site. (Which reminds me that I need to backup my test site!).
Also, another good thing is to remember to backup your files also. If you don't store attachments/avatars/etc in the database, then they are in the filesystem and won't get backed up when you backup your database!
I actually use the db script in cron.daily, and toss this guy in cron.weekly to nab the filesystem.
Code:
# Filesystem backup
tar -czf /path/to/backups/sitename-`date --iso-8601`.tar.gz /path/to/httpdocs/
02-24-2008, 06:15 PM
Threaded Mode