On Thursday, 14. March 2002 15:13, Andrew Hazen wrote:
Can I just write the mysql commands as a .sql file and tell Unix to
execute it? Or is there another way?
When you already use PHP, why don't use php-cli and execute it via cron?!
Regards
Georg
You sure can do it..
Just put your sql commands into a .sql file and use mysql file.sql syntax
to to have them executed by mysql. And you can always use cron in Unix to do
it periodically.In your Unix box do:
man crontab
man cron
to learn more about cron jobs. You can also consult to
Hi Andrew,
Let me first say that I am used to using mysql through PHP rather than
command line . . .
And, as I understand it mysql does not support any sort of timers.
I need to use a Unix command like cron to automate either a mysql
command or php script to output a selection from a few