MySQL BackUp - 1.1

# 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

unuseable
very buggy

I gave this a try because I was doing backups using mysqldump and finding it a pain. phpMyAdmin is great but won't work for mid to large databases.

Mysqldump turns # comments to -- which means I have to take the file into bbEdit and do the find replace... also it seemed necessary to add in the DROP IF EXISTS, CREATE and USE statements.
Unfortunately when I ran MySQL Backup I got this as the first few lines:
-- MySQL dump 9.07
--
-- Host: localhost Database: officeapp
---------------------------------------------------------
-- Server version 4.0.12-standard

--
-- Current Database: officeapp
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ officeapp;

The -- are in there and why this /*!32312 IF NOT EXISTS*/
This is a good start but much remains to be done?
First... replace those --
Second ... allow for full DROP, CREATE and USE statements

MySQL databases can also be backed up in a couple of other ways:
1. Using the "Export" feature in phpMyAdmin (freeware -- search this site).
2. As part of a complete HD backup, using, for example, Retrospect.
Don't mean to knock this program; just pointing out that it's not the only way to accomplish this goal.

not working for me. trying to backup a local mysql as the root mysql user i get:

Applescript error. The variable commandLocation is not defined. (-2753)