NYCPHP Meetup

NYPHP.org

[nycphp-talk] using PHP to import large-ish SQL into mysql

Daniel Convissor danielc at analysisandsolutions.com
Tue Oct 20 20:23:23 EDT 2009


Hola:

On Tue, Oct 20, 2009 at 08:14:23PM -0400, Jake McGraw wrote:
> Modify your insert statements to take advantage of LOAD DATA INFILE:

Definitely a handy statement.  But you'll need to be granted "FILE" 
permissions (aka "File_priv") in MySQL, which is not enabled by default.  
And the input file needs to be formatted along the lines of a CSV file 
rather than as a series of SQL commands.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409



More information about the talk mailing list