Hey there. I've been struggling to get a CRON job setup to download a CSV file on a daily basis. I know the CRON syntax, that's not the problem, I just need to figure out what command to use to make the file download to a specific directory on my server. I'm pretty rusty on my Linux and I'm struggling. Any tips or advice?
I've done something similar (I wasn't storing the database on the server) but I just cheated, wrote a script in PHP to handle everything and then called that script using a cron job.
I know you said you are familiar with setting up a cron job but if you are interested I wrote an overview on my blog