I have a freebsd machine v8 which has mysql on it with a database called "slave_data" and a table called "valid_local_users" with a column called "email_address".
what I want to do is run a script every 5 mins to extract "email_address" and write each record to a file.
file needs to looks like.
I know that i need to create a script and then use the crontab to schedule however i dont really know much about the script i need to write.
Could I please have some example or pointers.
I have googled but I dont fully understand all the points.