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

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 :
running the sql from the command line (os script) is built-in into mysql:

a small tutorial:
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.