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! 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. 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
Archived
This topic is now archived and is closed to further replies.