Re: FN-FORUM: Suggestions please

date posted 30th January 2006 11:25

They will definately be on different machines - Pam


----- Original Message -----
From: "Graham Stark" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, January 30, 2006 11:57 AM
Subject: Re: FN-FORUM: Suggestions please


>
> Hi,
>
> If the data and the database are on the same machine or the database is
> contactable over the network, then possibly mysqlimport running as a
> cron job is all you need. Or you can run php quite happily from within a
> cron job if you need, say, to rearrange the data before loading it.
>
> Graham
>
>> I am after a job where there will be csv files on a ftp server that will
>> need uploading to a database once a day and I am trying to work out the
>> best
>> way to do it. I gather you need "allow_url_fopen = On" set in php.ini to
>> be
>> able to use the ftpwrapper. Is it likely to be set to on? It should be in
>> php as far as I know unless they change their mind. I was wondering about
>> setting up a cron job to do it. Has anyone done anything similar as I am
>> looking for pointers in the right direction?
>>
>>
>> Thanks
>> Pam
> --
> Graham Stark, Virtual Worlds
> phone: (+044) 01908 618239 mobile: 07952 633185
> skype: graham_k_stark
> Homepage http://www.virtual-worlds.biz/people/graham_s
> Virtual Chancellor http://www.virtual-worlds.biz/vwc
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>