do shell script (file)

I’m using an mysqldump for years an never failed once. What it does is dumping all databases, zip it and send it over ftp to the backup server. That your file is empty is comes probably because something wrong with your parameters given to the mysqldump command (you need to use the full path). Then when it is not working should be looking in console and see which errors are shown there.

For instance when you’re using parameters with special characters like an password you should use parameter expansion or quote your parameters on the command line. Most common mistake is made here.

OK that’s what I’m chasing up now.

The path for the Mountain Lion Server is /usr/local/mysql/bin/mysqldump ?

I also couldn’t find any entries for mysqldump in the console. But that’s where I am now, headed down that path exactly.

Actually, I just put in the full path to mysqldump and it worked. I modified the PATH in the root’s bash_profile, and logged out and back in, and that didn’t help.

Hey that’s excellent.

Thanks to everybody for all your help. Pancakes for everyone (something I heard recently, found it funny).

Cheers