I want to run a daily cron dump of my MySql system using something like mysqldump -A > File.sql
I have a .my.cnf file that specifies host user and password, but this is not available to the cron script when it is run. I would prefer using the config files (sa .my.cnf) than hard coding the user and password in the script. Is this because .my.cnf is not available to cron when it loads (I think as root) or some other thing I may be missing. Just typing mysqldump -A > file.sql works as root user, but not in the cron.daily script mydump.cron that has that exact line in it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
