# Terminal is used for testing scripts that you intend to run using cron.  Script it,
# crontab it, forget it.  Done once, done right (enough), repeats at intervals forever.

#!/bin/sh

if [ ! -e /Users/me/Desktop/mysql_backup.sql.bz2 ]
then
	if /usr/local/mysql/bin/mysqladmin --user=me --password=xxxxxxxx refresh
	then
		if /usr/local/mysql/bin/mysqldump --opt --all-databases --user=me --password=xxxxxxxx >/tmp/mysql_backup.sql
		then
			if /sw/bin/bzip2 /tmp/mysql_backup.sql
			then
				if mv /tmp/mysql_backup.sql.bz2 /Users/me/Desktop
				then
					chown me:admin /Users/me/Desktop/mysql_backup.sql.bz2
				fi
			fi
		fi
	fi
fi