Hello -
I have the following command to back up a MySQL database on a remote machine. Works beautifully from the command line when run manually as root:
mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database > /Dumps/my_database.dump
This results is a nifty SQL file with data.
However, when I attempt to run the same command from the root user's crontab, it results in an empty file.
Does the PATH setting for jobs run by cron include the directory where mysqldump is located?
Any idea what I'm doing wrong. The command is running from root's cron file. The file has rw privs for root and the enclosing directory is owned by root. It doesn't have a problem running manually...
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
