Alright, I think I have it (I’m just waiting to make sure cron fires off and runs everything)! It’s very simple, and probably pretty dirty - but hey I’m not a whiz with shell scripting, nor cron so I think what I have is pretty sweet.

Because I’m lazy (I’m a programmer!) and I know I wouldn’t remember to run backups in an normal fashion, I wanted to make a system to run them automatically, think set it and forget it (wait wasn’t that an infomercial of some type?). So without further adieu…

The Shell script:

#!/bin/sh
export PATH=/usr/local/bin:/bin:/usr/bin
mysqldump --opt -uUsername -pPassword --all-databases >
~/db_backup_tmp/all-db-backup.sql &&
mv ~/db_backup_tmp/all-db-backup.sql ~/db_backup/all-db-backup.sql

The PHP script:

$file = "~/mysql_backup.sh";
exec($file);

Calm down, I’ll explain it…

So first we have the shell script.

#!/bin/sh

From Wiki

Posted in Bash, MySql, PHP, Programming No Comments »

Granted, I’m not trying to sound like a smarty pants here because I really know absolutely nothing about cron and how it works.

So let’s start from the beginning (moves hands to symbolize starting a flash back sequence)

From Wiki

In computing, cron is a time-based scheduling service in Unix-like computer operating systems. The name is derived from Greek chronos (??????), meaning time.

cron has been recreated several times in its history.

Say you want something to automatically run on your server (linux/unix) at certain timed intervals, and example would be, oh say a backup or other routines that need to be run at certain intervals. On a Drupal site I run, they have a built in script to update things using cron. It will update a list of rss feeds and other routine maintenance items. So I first started out with looking at the Drupal site for any documentation (shhhh, it’s not like I asked a guy for directions) on how to set it up. There were plenty of examples shown, but didn’t make a whole of sense to me.

Posted in Bash, Programming No Comments »