Sql Export To Csv File Though A Cron Job?

[craigis]

I was wondering if it is possible to export data from a sql database to a csv file on the web server. I initially thought of something like a cron job so it can run at a set interval but I don't even know if this is possible.

 

The reason behind this is that I need products to be exported from a e-commerce store so they can be imported by a crawler that will look for the specific file everyday.

[Ice IT Support]

I know it is possible through phpMyAdmin, not sure about cron.

[craigis]

Yea I've seen the export option in phpmyadmin and it will export to a csv file but I have yet to find a way to schedule a recurring export of a db.