divinedesigns1 Posted May 20, 2012 Share Posted May 20, 2012 hello, how everyone? ok i know how to export the data from mysql to excel manually "btw thesci in phpmyadmin you can export xls files from there now, i just found out and though i let you know" but i dont want to be doing that every week, so i was wondering how i can export it automatically so that all i have to do is take the file out of the ftp and hand it over "still that's too much work, but for now thats the plan" how can i do this? Link to comment Share on other sites More sharing options...
birbal Posted May 20, 2012 Share Posted May 20, 2012 for that you have to make a script which will fetch data from db and put it in excel file and you need to schedule the task AKA cron jobs to run it periodicaly. Link to comment Share on other sites More sharing options...
divinedesigns1 Posted May 20, 2012 Author Share Posted May 20, 2012 ok thanks, now i need to fine out what cron jobs are Link to comment Share on other sites More sharing options...
Guest So Called Posted May 20, 2012 Share Posted May 20, 2012 http://www.google.com/search?q=cron+job Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now