I've created a mysql database solutions that works perfectly in Mac OS X 10.1.4. However, I've purchased a new G4 running 10.1.2 (Jaguar) and I'm having one problem.
I need to update the database every 5 minutes with sports scores that are exported from another system. I'm using the mysqlimport command, and it works perfectly inside a shell script when run from the command line. When I try to execute that same shell script with cron, it will not import the file. The exact script works perfectly in Mac OS 10.1.4. Also, if I run the mysqlimport command as part of the crontab file (not calling the shell script) it works, but that doesn't help me because I need to do other things to the file before imports the file, and I'd rather not have multiple crons running. I suppose it could be a permissions problem somewhere, but I've tried running it as root as well as a regular user with admin rights, and it still doesn't work. Any ideas? Keith Warren Systems Editor The Clarion-Ledger 601-961-7058 --------------------------------------------------------------------- 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
