I'd like to run a SQL query via cron. I figured I'd create a
.sql file and call it from a script that I place in the cron folder. The query is relatively large and not written by me, so I'd prefer to not have to re-create it in PHP.
Can anyone provide some assistance? I am not exactly clear on how to run the SQL query from the script. Thanks in advance.
EDIT: Just for some background info, the query is intended to grab data from multiple tables and organize it in a csv file.