MySQL Forums
Forum List  »  PHP

Re: Automating LOAD DATA INFILE with data collected regularly on an other system (Windows)
Posted by: Peter Brawley
Date: October 04, 2015 03:27PM

> The 'local' system has no web server and no PHP - just an Access database
> used to 'pre-process' the data that needs to be uploaded to the remote web site's My SQL database.

> My idea, when the dataset is large, is not to use the above append query
> but to create instead a csv file which I can then upload using LOAD DATA LOCAL INFILE

Access will likely still be a bottleneck with big data tranches.

> What I am struggling with is the automation of this on a Windows system so I can bypass Workbench.

That's what Perl and PHP are for.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.