Page 1 of 1

import csv inside zip to mysql auto

Posted: Sat Aug 21, 2010 5:54 pm
by peterhall
hi there. :?

i'm trying toi import a csv file, that is inside of a zip file everyday at 2 am to mysql data base, is this possible?

tk u !!

Re: import csv inside zip to mysql auto

Posted: Sat Aug 21, 2010 5:59 pm
by shawngoldw
Look up cron jobs. They will let you run a script at a certain time every day

Shawn

Re: import csv inside zip to mysql auto

Posted: Sat Aug 21, 2010 6:12 pm
by peterhall
how I do that? newbie speaking... :oops:

Re: import csv inside zip to mysql auto

Posted: Sat Aug 21, 2010 6:15 pm
by shawngoldw
http://lmgtfy.com/?q=cron+job
:D

I'm no expert on cron so I can help you a little if you have any questions, but you may need to wait for someone else to weigh in.


Shawn