craigis Posted February 5, 2012 Share Posted February 5, 2012 I was wondering if it is possible to export data from a sql database to a csv file on the web server. I initially thought of something like a cron job so it can run at a set interval but I don't even know if this is possible. The reason behind this is that I need products to be exported from a e-commerce store so they can be imported by a crawler that will look for the specific file everyday. Quote Link to comment Share on other sites More sharing options...
Ice IT Support Posted February 6, 2012 Share Posted February 6, 2012 I know it is possible through phpMyAdmin, not sure about cron. Quote Link to comment Share on other sites More sharing options...
craigis Posted February 6, 2012 Author Share Posted February 6, 2012 Yea I've seen the export option in phpmyadmin and it will export to a csv file but I have yet to find a way to schedule a recurring export of a db. Quote Link to comment 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.