best way to export 4 fields from a mysql db every 15 minute

We have a mysql database with a user file, the table stores about 12 items per user. We want to export to a csv (4 items only) and drop to a selective folder. Then rerun  the script again ( every 15 minutes) with only adding new users since the last run time.

Any idea's

Thanks,
Lowell SwitzerCTO / Systems EngineerAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ok, what is the problem here?
running every 15 minutes? => scheduler application exist on any OS (windows => Scheduled Tasks, unix/linux => cron)
running the sql and dump to file => mysql can run a INTO OUTFILE syntax : https://dev.mysql.com/doc/refman/5.1/en/select-into.html
running the sql from the command line (os script) is built-in into mysql: http://dev.mysql.com/doc/refman/5.6/en/mysql.html

a small tutorial:
http://www.mysqltutorial.org/mysql-export-table-to-csv/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.