[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