LuciBKen Posted June 19, 2007 Share Posted June 19, 2007 Hey everyone, I was wondering if it was possible to schedule mysql to automatically export to a csv file daily? Or, am I going to have to write a php script to do it? Any links for tutorials to whichever would be helpful. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/56275-is-this-possible-scheduleing-a-daily-csv-report/ Share on other sites More sharing options...
Wildbug Posted June 19, 2007 Share Posted June 19, 2007 You can actually use a CSV database engine (but that may not be what you want): http://dev.mysql.com/doc/refman/4.1/en/csv-storage-engine.html mysqldump is supposed to support dumping to CSV format, but the manual page doesn't give specifics. Google "mysqldump csv" Also google "cron" for the scheduling bit. Quote Link to comment https://forums.phpfreaks.com/topic/56275-is-this-possible-scheduleing-a-daily-csv-report/#findComment-278003 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.