Copy MYSQL table to CSV and automatically transfer file

[NeillH]

Hi - Newbie here so go easy.

 

I want to get a MYSQL table from my web server to a local PC, so I found some PHP code that creates a csv file and brings up the download prompt in ie.  However I want to automate transfer using windows scheduler, so unattended file transfer can happen.

 

The PHP script works fine, is it possible to do this through windows scheduler?, I know the other option would be to create a cron job to create a csv file then use ftp to gte the file, but I could not find any code to do this.

 

Any help most welcome

 

Regards Neillh